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 |
|---|
|