About
time duration is known as interval in SQL.
Syntax
An SQL interval data type descriptor contains:
- the name of the interval data type (INTERVAL);
- an indication of whether the interval data type is :
- the <interval qualifier> that describes the precision of the interval data type.
Operations
Datetime - Datetime = Interval
Datetime + or - Interval = Datetime
Interval + Datetime = Datetime
Interval + or - Interval = Interval
Interval * or / Numeric = Interval
Numeric * Interval = Interval