You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.
ADD PERIOD TO DATETIME
Calculates a new dateTime by adding a specified period to a specified dateTime.
Syntax
dateTime + number period
Inputs
- dateTime - 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
- dateTime
Examples
| Expression | Result | Type |
|---|---|---|
| 01-01-2015 13:23:04 + 1 DAYS | 02-01-2015 13:23:04 | DateTime |
| 01-01-2015 13:23:04 + 25 HOURS | 02-01-2015 14:23:04 | DateTime |
| 01-01-2015 13:23:04 + 60 SECONDS | 01-01-2015 13:24:04 | DateTime |
| 01-01-2015 13:23:04 + 1 MINUTES | 01-01-2015 13:24:04 | DateTime |
Overview
Content Tools