Date formatting issues - maybe new ODBC

Connectivity

Date formatting issues - maybe new ODBC

We migrated to a new production Windows ETL server and a new ODBC version 3.01.00.06. There was no change to the d/bTeradata: V2R.05.01.02.43.
We now have a job that is returning current_date in a different format and we do not understand why.

Until today we could compare a date from a table to the current_date but now the log is showing a new format from the SQL statement
CAST(Current_Date as CHAR(10)) AS Actual_Dt
LOG: Extracted Current_Dt:2009-09-14 Actual Date: 09/09/14 - Extracted Current_Dt Does NOT EQUAL Actual_Dt

We run the select in SQL Assistant and see the same format as the script output
select current_date returns 09/14/2009
select current_date (format 'yyyy-mm-dd') returns 09/14/2009
select CAST(Current_Date as CHAR(10)) AS Actual_Dt returns 09/09/14

What can we do to get the format to come back as 2009-09-14.
1 REPLY
Teradata Employee

Re: Date formatting issues - maybe new ODBC

Check the DateTime Format in the Teradata ODBC Driver Options dialog box. I suspect that you had set it "AAA" before and now it is defaulted to "III".

Start from "ODBC DataSource Administrator"; Select the DSN and Click Configure, next click the "Options >>" button.