The DataBlade API provides support for the following kinds of 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:
A year-month interval value specifies the number of years and months, years, or months that have passed.
A day-time interval value specifies the number of days and hours, days, or hours that have passed.
The DataBlade API provides support for date-time or interval data in both text and binary representations.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]