Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Exporting & Importing Dates in SQL Assistant
From:   Dempsey, Mike

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.


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

Mike Dempsey
Teradata Client Tools

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023