SAND CDBMS SQL Reference Guide
Date/Time Arithmetic

 

Previous Topic:
Labeled Durations
Chapter Index
Next Topic:
Interval Arithmetic

 

Intervals and Date/Time Values

Intervals can be added to or subtracted from date/time data types. Such arithmetic expressions will always evaluate to the same data type as the date/time value in the expression. The basic arithmetic expressions and their result types are summarized in the following tables:

DATE

Expression Result Type
<DATE> – <date interval> DATE
<DATE> + <date interval> DATE
<date interval> + <DATE> DATE


TIME

Expression Result Type
<TIME> – <time interval> TIME
<TIME> + <time interval> TIME
<time interval> + <TIME> TIME


TIMESTAMP

Expression Result Type
<TIMESTAMP> – <timestamp interval> TIMESTAMP
<TIMESTAMP> + <timestamp interval> TIMESTAMP
<timestamp interval> + <TIMESTAMP> TIMESTAMP
<TIMESTAMP> – <date interval> TIMESTAMP
<TIMESTAMP> + <date interval> TIMESTAMP
<date interval> + <TIMESTAMP> TIMESTAMP
<TIMESTAMP> – <time interval> TIMESTAMP
<TIMESTAMP> + <time interval> TIMESTAMP
<time interval> + <TIMESTAMP> TIMESTAMP


Examples

Expression Result
13 DAYS + '2003-12-19' 2004-01-01
'11:30:45' - 156 SECONDS 11:28:09
'2003-12-19-12.35.52.544000' - 75 HOURS 2003-12-16-09.35.52.544000

 

Previous Topic:
Labeled Durations
Chapter Index
Next Topic:
Interval Arithmetic