Archives of the TeradataForum
Message Posted: Sun, 14 Apr 2013 @ 19:09:17 GMT
Asifuddin MD wrote:
It's not a SQLA option, it's ODBC, so you'll find the info in the ODBC manual.
It's about how DATE/TIME/TIMESTAMP datetypes are treaed by the ODBC driver. "I" means INTEGER, mainly used for compatibility with old applications (at least for TIME and TIMESTAMP), "A" means ANSI, which is preferred.
The default used to be III, but IAA or AAA is recomended.
For dates I/A is similar to SET SESSION DATEFORM = INTEGERDATE/ANSIDATE.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|