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.