Archives of the TeradataForum
Message Posted: Tue, 04 May 2004 @ 17:05:33 GMT
You probably specified mm/dd/yyyy as your default format in V2R4.1 in DBS Control Record - General Field 21. Default Date Format
but in V2R5 this Field is obsolete (Reserved for future use).
Setting 15. DateForm to ANSIDate doesn't help, because ANSI always expects date in yyyy-mm-dd.
Specify date columns as CHAR(10) instead of DATE and Cast it to a Date. This will use the column's default format.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|