When i migrate Date/Timestamp/Time Data from SQL Server to Teradata , I can see 6 hours of difference among the dates where teradata date/Timestamp is behind . Please help me on this .
Thanks in advance !!
Sounds like a mismatch in the implicit / assumed time zone. In addition to OS time zone settings on the servers:
Check dbscontrol settings SystemTimeZoneHour, SystemTimeZoneMinute, TimeDateWZControl, SystemTimeZoneString
Also look at TimeZoneHour, TimeZoneMinute settings for the load username vs. the query username.
And sometimes the time zone setting for the client displaying the results can matter as well.