Archives of the TeradataForum

Message Posted: Wed, 27 Feb 2008 @ 16:32:44 GMT

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

David:

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,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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