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 |