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:

Table 1. Rules for date/time addition
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