ADD PERIOD TO DATETIME
Calculates a new dateTime by adding a specified period to a specified dateTime.
Syntax | Code Block |
|---|
dateTime + number period |
InputsdateTime - The dateTime that you want to add the specified period to. number - Specifies how may periods you want to add to the dateTime. period - A keyword that specifies which time unit to add. Valid units are DAYS, WEEKS, MONTHS, YEARS, HOURS, MINUTES and SECONDS.
Return type
Examples | Expression | Result | Type |
|---|
| DATETIME("2015-01-01 -2015 13:23:04") + 1 DAYS | 022015-01-2015 02 13:23:04 | DateTime | | DATETIME("2015-01-01 -2015 13:23:04") + 25 HOURS | 022015-01-2015 02 14:23:04 | DateTime | | DATETIME("2015-01-01 -2015 13:23:04") + 60 SECONDS | 2015-01-01 -2015 13:24:04 | DateTime | | DATETIME("2015-01-01 -2015 13:23:04") + 1 MINUTES | 2015-01-01 -2015 13:24:04 | DateTime |
|