Archives of the TeradataForum
Message Posted: Tue, 04 May 2004 @ 17:05:33 GMT
| Subj: | | Re: Multiload Problem With Date Columns - V2R5.1 |
| |
| From: | | Dieter Noeth |
PriceJ wrote:
| | Sorry - our layout actually is CHAR(10) with incoming values in the form mm/dd/yyyy. | |
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.
Dieter
| 
