Rules for date/time addition
If a date/time value is the operand of an addition, the other operand must be a duration.
The operands of date/time addition must be as shown in the following table:
If one operand is a: | The other operand must be: |
---|---|
Date | A duration of years, months, or days |
Time | A duration of hours, minutes, or seconds |
Timestamp | Any valid duration |