DATEADD()

Available in: DSQL, PSQL

Added in: 2.1

Description: Adds the specified number of years, months, days, hours, minutes, seconds or milliseconds to a date/time value.

Result type: DATE, TIME or TIMESTAMP

Syntax:

DATEADD (<args>)

<args>      ::=  <amount> <unit> TO <datetime>
                 | <unit>, <amount>, <datetime>

<amount>    ::=  an integer expression (negative to subtract)
<unit>      ::=  YEAR | MONTH | DAY
                   | HOUR | MINUTE | SECOND | MILLISECOND
<datetime>  ::=  a DATE, TIME or TIMESTAMP expression

The result type is determined by the third argument.
With DATE arguments, only YEAR, MONTH and DAY can be used.
With TIME arguments, only HOUR, MINUTE, SECOND and MILLISECOND can be used.

Examples:

dateadd (28 day to current_date)
dateadd (-6 hour to current_time)
dateadd (month, 9, DateOfConception)
dateadd (minute, 90, time 'now')
dateadd (? year to date '11-Sep-1973')