The following arithmetic operations are permitted for DateTime and Interval data types.
First Value Type | Operator | Second Value Type | Result Type |
---|---|---|---|
DateTime | - | DateTime | Interval |
DateTime | + | Interval | DateTime |
DateTime | - | Interval | DateTime |
Interval | + | DateTime | DateTime |
Interval | + | Interval | Interval |
Interval | - | Interval | Interval |
Interval | * | Number | Interval |
Interval | / | Number | Interval |
Number | * | Interval | Interval |