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 |
---|---|---|
DATETIME("2015-01-01 13:23:04") + 1 DAYS | 2015-01-02 13:23:04 | DateTime |
DATETIME("2015-01-01 13:23:04") + 25 HOURS | 2015-01-02 14:23:04 | DateTime |
DATETIME("2015-01-01 13:23:04") + 60 SECONDS | 2015-01-01 13:24:04 | DateTime |
DATETIME("2015-01-01 13:23:04") + 1 MINUTES | 2015-01-01 13:24:04 | DateTime |
Overview
Content Tools