Details of the ODBC Interface¶
This section describes information specific to the ODBC interface of Denodo.
How the ODBC Interface Reports the Datetime and Interval Data Types¶
The ODBC interface of Denodo follows the same protocol as PostgreSQL.
The table below lists how the data types of Denodo are mapped to the data types of PostgreSQL.
Type Name in Denodo |
Type Name for PostgreSQL |
Type Code for PostgreSQL |
|---|---|---|
localdate |
date |
1082 |
time |
time |
1083 |
timestamp |
timestamp |
1114 |
date (deprecated) |
timestamptz |
1184 |
timestamptz |
timestamptz |
1184 |
interval_year_month |
interval |
1186 |
interval_day_second |
interval |
1186 |
The types date and timestamptz are reported with the same type (TIMESTAMP WITH TIMEZONE) so a client application cannot distinguish them. This facilitates the upgrade from Denodo 6.0 or previous versions. Client applications do not need to distinguish between these types and treat both as timestamptz.