January 17, 2015 at 7:49 pm
how to manage data across different data centers ? We have some tables with date time fields with default getdate(). What changes we need to do so that we don't see any issues with data.
January 18, 2015 at 4:51 am
For managing dates like that, I'd suggest using the UTC date functions; SYSUTCDATETIME or GETUTCDATE. You can then use the timezone offsets to show the dates as local if necessary.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 18, 2015 at 6:57 am
Grant Fritchey (1/18/2015)
For managing dates like that, I'd suggest using the UTC date functions; SYSUTCDATETIME or GETUTCDATE. You can then use the timezone offsets to show the dates as local if necessary.
What about the changes we have to do with the existing fields and data?
January 18, 2015 at 7:08 am
Very few choices there. You'll have to clean the data. Decide which dates are supposed to be correct and modify them. No other way around that.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply