Manualshelf

Data Transformation Engine ODBC Adapter Reference Guide

ManualsBrandsHP ManualsServerHP NonStop G-Series
12345678910
Chapter 2 - Database Columns and Types Date and Time Formats
ODBC Adapter Reference Guide
8
ODBC Data Type
Interpret as
Item Subclass,
Presentation
Length
SQL_DOUBLE Binary Number, Float 8
SQL_LONGVARCHAR Character Text *
SQL_BIT Character Number, Integer *
SQL_TINYINT Character Number, Integer 4
SQL_BIGINT Character Number, Integer 20
SQL_BINARY Binary Text *
SQL_VARBINARY Binary Text *
SQL_LONGVARBINARY Binary Text *
SQL_DATE Character Date & Time *
SQL_TIME Character Date & Time *
SQL_TIMESTAMP Character Date & Time *
SQL_INTERVAL_HOUR Character Text *
SQL_INTERVAL_MINUTE Character Text *
SQL_INTERVAL_SECOND Character Text *
SQL_INTERVAL_YEAR_TO_MONTH Character Text *
SQL_INTERVAL_DAY_TO_HOUR Character Text *
SQL_INTERVAL_DAY_TO_MINUTE Character Text *
SQL_INTERVAL_DAY_TO_SECOND Character Text *
SQL_INTERVAL_HOUR_TO_MINUTE Character Text *
SQL_INTERVAL_HOUR_TO_SECOND Character Text *
SQL_INTERVAL_MINUTE_TO_SECOND Character Text *
* The DBMS dictates the length of this type.
Date and Time Formats
When using columns defined as dates and times in ODBC databases, the format
for both input and output is:
Note Precision can be specified on output. For example, a precision of 4 would change a
date of format from ccyy-mm-dd to ccyy.