Date-time or interval data
The DataBlade® API provides support for date-time or interval data in both text and binary representations.
The DataBlade®
API provides
support for the following fixed-point data, which correspond to existing
SQL data types.
| Type of fixed-point value | SQL data type |
|---|---|
| Date and time, date, or time | DATETIME |
| Year and month interval or day and time interval | INTERVAL |
Date-time data is an instant in time that is expressed as a calendar date and time of day, just a calendar date, or just a time of day. A date-time value can also have a precision and a scale. The precision is the number of digits required to store the value. The scale is the end qualifier of the date-time value, such as YEAR TO HOUR.
Interval data is a span of time that is expressed as the number
of units in either of the following interval classes:
- Year-month intervals
- A year-month interval value specifies the number of years and months, years, or months that have passed.
- Day-time intervals
- A day-time interval value specifies the number of days and hours, days, or hours that have passed.