Types

The Types tab contains settings for handling Date, Time and Timestamp formats.

Table 1. 1010data ODBC driver: Types tab
ODBC Driver Setting/Linux Keys Default value Short description Use case
HHMMSS

{MapHHMMSS}
SQL_TIME Time format N/A
Timestamp

MapTimetamp
SQL_TIMESTAMP Timestamp format N/A
YYYYMMDD

{MapYYYYMMDD}
SQL_DATE Date format N/A