INTERVAL data type
The HCL OneDB™ INTERVAL
data type stores a value that represents a span of time. INTERVAL
data types comprise two types: year-month intervals and day-time intervals. A
year-month interval can represent a span of years and months, and
a day-time interval can represent a span of days, hours, minutes,
seconds, and fractions of a second. For more information about the
INTERVAL data type and definitions of qualifier, precision,
and fraction, see the following publications:
- HCL OneDB Guide to SQL: Tutorial
- HCL OneDB Guide to SQL: Reference
- HCL OneDB Guide to SQL: Syntax