Archives of the TeradataForum

Message Posted: Wed, 04 May 2005 @ 13:38:25 GMT

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

The older versions of Queryman always exported dates in ODBC format YYYY-MM-DD.

The newer versions os SQL Assistant export dates in the format requested by your locale (regional) settings. In the US that would normally be MM/DD/YY or MM/DD/YYYY.

This was done in order to ensure that dates were displayed in your country's 'expected' format.

When importing (character) dates to Teradata the required format depends on the table definition. Apparently your tables expect YYYY-MM-DD format, (since the old version worked) but other tables might require MM/DD/YYYY or DD/MM/YYYY.

The only real solution here is to ensure that the export is performed with the date format required for Import.

As you found out, Format clauses (by themselves) are ignored. However if you also cast the column to CHAR(10) the format will be applied.

example:

     DateCol (FORMAT 'YYYY-MM-DD')(CHAR(10))

Mike Dempsey
Teradata Client Tools

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