Previous
Topic:
Labeled Durations |
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 |
Next
Topic: Interval Arithmetic |