So Teradata needs the date in internal format? Don't recall hearing that before. Have you verified that you get the correct date in the database rather than it works because the job no longer throws the error?
-craig
"You can never have too many knives" -- Logan Nine Fingers
I would expect a server job to behave this way. One exception is ODBC, where you have to specify this behaviour by specifying Date as the data element.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Because, in server jobs, the representation of the Date data type is "internal format". Most Connectors (and their predecessors) perform the conversion automatically where the metadata are consistent.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Ah... having dealt basically 100% with Oracle where I would always treat a DATE as a full Timestamp with explicit control over the time portion, that never really clicked for me.
-craig
"You can never have too many knives" -- Logan Nine Fingers