SQLServer - Teradata Timestamp Issue

Database
SAP
Enthusiast

SQLServer - Teradata Timestamp Issue

Hi ,

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 !!

2 REPLIES
Enthusiast

Re: SQLServer - Teradata Timestamp Issue

Have you checked the timstamp settings on both the servers too? say like selecting the timestamp.....?

Teradata Employee

Re: SQLServer - Teradata Timestamp Issue

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.