Binary C Type to Period SQL - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

The source data must be in the format described in Period SQL to Character C type Conversion.

An application can provide its own value for the precision of the period source data by setting the SQL_DESC_PRECISION field of the application descriptor. The default precision for the source data is the same as the precision of the target as indicated in the DecimalDigits argument to SQLBindParameter. For example, a value of 14250000 in the Second field and DecimalDigits=2 would allow the value to be inserted into a PERIOD(TIME(2)).

The ColumnSize argument to SQLBindParameter is ignored for Period data types.