 |
 |
Archives of the TeradataForum
Message Posted: Sun, 14 Apr 2013 @ 19:09:17 GMT
| Subj: | | Re: DateTimeFormat's in SQLA/TD |
| |
| From: | | Dieter Noeth |
Asifuddin MD wrote:
| | I am confused on the datetimeformats in SQLA which state AAA,III and so on.. Any explanation on all those please or a direct location I
can refer to. | |
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.
Dieter
| |
