Arithmetic operations can be carried out across data types.
The following arithmetic operations can be carried out:
Addition, subtraction, multiplication and division of numbers return numbers.
If you add a number to a date, the date is increased by the number of days specified by the number.
If you subtract a number from a date, the date is decreased by the number of days specified by the number.
Adding or subtracting a date with a time results in a timestamp.
Example
The addition of a date to a number increases the date by the number of days that correspond to the number.