Page History
Learn more about the date and time functions DATETIME, DATE, SECONDS, SECONDS_BETWEEN, MINUTES, MINUTES_BETWEEN, HOURS, HOURS_BETWEEN, DAYS, DAYS_BETWEEN, WORKINGDAYS, WORKINGDAYS_BETWEEN, WEEKS, WEEKS_BETWEEN, MONTHS, MONTHS_BETWEEN, YEARS, YEARS_BETWEEN, BETWEEN, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, TODAY, NOW, WEEKNUMBER, DAYOFWEEK.
Overview
Function | Description |
---|---|
DATETIME | Creates a dateTime value out of integers or numbers. |
DATE | Creates a date value out of integers or numbers. |
ADD PERIOD TO DATE | Calculates a new date by adding a specified period to a specified date. |
ADD PERIOD TO DATETIME | Calculates a new dateTime by adding a specified period to a specified dateTime. |
SUBTRACT PERIOD FROM DATE | |
SUBTRACT PERIOD FROM DATETIME | |
PERIOD BETWEEN | Calculates the period between two date or dateTime objects. |
WORKINGDAYS BETWEEN | |
WORKINGDAYS_BETWEEN | |
YEAR | |
MONTH | Returns the month of a date or dateTime value. |
DAY | Returns the day of a date or dateTime value. |
HOUR | Returns the hour of a dateTime value. |
MINUTE | Returns the minute of a dateTime value. |
SECOND | Returns the second of a dateTime value. |
TODAY | |
NOW | Returns the current date and time of the server. |
WEEKNUMBER | |
DAYOFWEEK | Returns the number of the day within the week of a given date or dateTime value. |
Include Page | ||||
---|---|---|---|---|
|
...
Overview
Content Tools