Stuart McLachlan
stuart at lexacorp.com.pg
Wed Jul 16 20:20:02 CDT 2008
I doubt very much that SQL Server is changing data. The problem is more likely to be in how it is created (whether they are storing UTC or Local time) and how it is displayed. If they want to synchronize between time zones they need to store the times as UTC or store them as local time and also store the current UTC offset. On 16 Jul 2008 at 20:14, Susan Harkins wrote: > A reader has a peculiar question -- at least, it is peculiar to me. They > receive timestamped records from other time zones. When they receive them, > SQL Server adjusts them to the current time zone! I'm aghast, but that seems > to be what's happening. > > They control both sides of the data, so they're in a position to adjust > either end. > > I just wouldn't have expected that to happen. Is this normal? Is there an > easy way to tell SQL Server not to adjust time values? > > Susan H. > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com >