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 | Calculates a new date by subtracting a specified period from a specified date. |
SUBTRACT PERIOD FROM DATETIME | Calculates a new dateTime by subtracting a specified period from a specified dateTime. |
PERIOD BETWEEN | Calculates the period between two date or dateTime objects. |
WORKINGDAYS BETWEEN | Calculates the working days between two date or dateTime objects. |
WORKINGDAYS_BETWEEN | Alternative notation for WORKINGDAYS BETWEEN |
YEAR | Returns the year of a date or dateTime value. |
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 | Returns the current date of the server. |
NOW | Returns the current date and time of the server. |
WEEKNUMBER | Returns the week number within the year of a given date or dateTime value. |
DAYOFWEEK | Returns the number of the day within the week of a given date or dateTime value. |
Include Page |
---|
| Date and time function DATETIME |
---|
| Date and time function DATETIME |
---|
|
Include Page |
---|
| Date and time function DATE |
---|
| Date and time function DATE |
---|
|
Include Page |
---|
| Date and time function ADD PERIOD TO DATE |
---|
| Date and time function ADD PERIOD TO DATE |
---|
|
Include Page |
---|
| Date and time function ADD PERIOD TO DATETIME |
---|
| Date and time function ADD PERIOD TO DATETIME |
---|
|
Include Page |
---|
| Date and time function SUBTRACT PERIOD FROM DATE |
---|
| Date and time function SUBTRACT PERIOD FROM DATE |
---|
|
Include Page |
---|
| Date and time function SUBTRACT PERIOD FROM DATETIME |
---|
| Date and time function SUBTRACT PERIOD FROM DATETIME |
---|
|
Include Page |
---|
| Date and time function PERIOD BETWEEN |
---|
| Date and time function PERIOD BETWEEN |
---|
|
Include Page |
---|
| Date and time function WORKINGDAYS BETWEEN |
---|
| Date and time function WORKINGDAYS BETWEEN |
---|
|
Include Page |
---|
| Date and time function YEAR |
---|
| Date and time function YEAR |
---|
|
Include Page |
---|
| Date and time function MONTH |
---|
| Date and time function MONTH |
---|
|
Include Page |
---|
| Date and time function DAY |
---|
| Date and time function DAY |
---|
|
Include Page |
---|
| Date and time function HOUR |
---|
| Date and time function HOUR |
---|
|
Include Page |
---|
| Date and time function MINUTE |
---|
| Date and time function MINUTE |
---|
|
Include Page |
---|
| Date and time function SECOND |
---|
| Date and time function SECOND |
---|
|
Include Page |
---|
| Date and time function TODAY |
---|
| Date and time function TODAY |
---|
|
Include Page |
---|
| Date and time function NOW |
---|
| Date and time function NOW |
---|
|
Include Page |
---|
| Date and time function WEEKNUMBER |
---|
| Date and time function WEEKNUMBER |
---|
|
Include Page |
---|
| Date and time function DAYOFWEEK |
---|
| Date and time function DAYOFWEEK |
---|
|