Susan Harkins
ssharkins at gmail.com
Wed Jul 16 20:36:39 CDT 2008
That makes so much sense -- thank you Stuart. Susan H. >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 >> > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com >