Archives of the TeradataForum

Message Posted: Thu, 04 Apr 2002 @ 15:16:36 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

If you're on V2R4 or later, check to see if DATEFORM is set to ANSI. If this is the case the default formation will be 'yyyy-mm-dd' and any date literals entered this way will work fine - no guessing even though an attribute in the DB may have a different default FORMAT set. Also, Insure that your ODBC DATE FORMAT (Options) is set the way you want too - e.g. AAA or IAA, etc. As seen in previous messages this translates to DATE, TIME, TIMESTAMP positional values.

	<Prev	Next>		<<First	<Prev	Next>	Last>>