I fetched the formatted datetime field from source SQL server and used that to update the field in Teradata which resolved the issue. CONNECT TO SQLSVR (user=&Sqluser. password=&Sqlpass. datasrc=SQL_SRV ReadBuff=32767); SELECT MY_DTTM into :MY_MACRO_VAR FROM connection to SQLSVR ( select FORMAT(CAST([DATE] AS DATETIME2(6)),'yyyy-MM-dd hh:mm:ss.ssssss') AS [MY_DTTM] FROM [dbo].[CONTROL_TABLE] ); DISCONNECT FROM SQLSVR; QUIT; PROC SQL NOPRINT; CONNECT TO teradata (user=&Terauser password=&Terapass tdpid=dbc); EXECUTE ( UPDATE MY_TERADATA_TABLE SET MY_DTTM = CAST(%BQUOTE('&MY_MACRO_VAR.') AS TIMESTAMP(6) FORMAT 'MMDDYY:HH:MI:SS.SSS') ) BY teradata; EXECUTE (COMMIT) BY teradata; DISCONNECT FROM teradata; QUIT;
... View more