|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/14/2009 7:07:13 PM
Posts: 1,
Visits: 5
|
|
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.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/16/2009 3:03:20 PM
Posts: 152,
Visits: 454
|
|
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.
--Cal
|
|
|
|