I am fairly new to Teradata. I have been struggling to get exact format for all the dates in my select query when doing an export using BTEQ.
Here is my script :
"Exactly the same format as they are in the Teradata table" would be an internal binary representation; probably not what you really want.
BTEQ in FIELDMODE will use the FORMAT associated with the column to convert to character form. Other tools (e.g. SQL Assistant) typically convert the ODBC/JDBC/etc. driver format to the client's local form. You could ALTER the column format in the table, or explicitly CAST the date field(s) to some other format, or possibly SET SESSION DATEFORM=ANSIDATE; if what you want is yyyy-mm-dd format.
Please provide the SHOW TABLE. Need to see the data type and format for the column that contains the date.