SQL Server 2005, Replicating between timezones -


how sql server handle transfer of datetime columns when replicating between timezones?

sql server isn't timezone aware. if store 2:36 pm in east coast data ceneter, replicate data west coast data center, still 2:36 pm.

to around type of problem, of our servers set utc time. way know date/time in database correct utc, , if need adjust client display or reporting, can add/subtract offset date/time values regardless of server(s) data came from.


Comments