我的书签
添加书签
移除书签3 Date and time functions
All functions listed here are supported in:
Date and time functions cannot be used in the expression alone; at least one non-time-based function referencing the host item must be present in the expression.
The functions are listed without additional information. Click on the function to see the full details.
| Function | Description |
|---|---|
| date | The current date in YYYYMMDD format. |
| dayofmonth | The day of month in range of 1 to 31. |
| dayofweek | The day of week in range of 1 to 7. |
| now | The number of seconds since the Epoch (00:00:00 UTC, January 1, 1970). |
| time | The current time in HHMMSS format. |
Function details
date
The current date in YYYYMMDD format.
Example:
date()<20220101
dayofmonth
The day of month in range of 1 to 31.
Example:
dayofmonth()=1
dayofweek
The day of week in range of 1 to 7 (Mon - 1, Sun - 7).
Example:
dayofweek()<6
now
The number of seconds since the Epoch (00:00:00 UTC, January 1, 1970).
Example:
now()<1640998800
time
The current time in HHMMSS format.
Example:
time()>000000 and time()<060000
