Date/time arithmetic

 

Addition and subtraction are the only arithmetic operators applicable to date, time, and timestamp values.

You can increment and decrement a date, time, or timestamp by a duration; or subtract a date from a date, a time from a time, or a timestamp from a timestamp.

 

Parent topic:

Date, time, and timestamp data types

 

Related reference

Datetime arithmetic in SQL