Archives of the TeradataForum
Message Posted: Wed, 27 Feb 2008 @ 16:32:44 GMT
You are certainly welcome for my previous answers. I will attempt to give you more based on your last post:
1. you only define data coming into the utility as CHAR or even VARCHAR if it is that data type on the record. If it was exported as decimal, time, date, etc then you would define it as that same data type coming back into a load utility. In a layout the data type in the file is what is important because the load utility can figure out what is in the table via the Data Dictionary.
2. the default format in Teradata for a timestamp is 'yyyy-mm-dd hh:mi:ss.ssssss'). However, your data coming in seems to be that based on the format you used (except for the hh24 (default) and ff6 at the end. Since it is already in that format, there is no need to CAST it. In Teradata utilities if you need to convert and format, it is normally done as a part of the SQL, but not with a CAST: set datacolumn = :inchardate (date, format 'mm-dd-yyyy') <- only needed because it is not 'yyyy-mm-dd'. There is also a DATEFORM that can be requested in the utilities, but this is between this default format and 'yy/mm/dd'.
Hope this helps,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|