UTC date(*) is a great thing. Really. If you decide to implement it into a database, PLEASE, PLEASE, PLEASE do your best to implement it across the board for ALL timestamps, and include conversions to aid your customers. If your product mixes timestamps between local time and UTC time, ad-hoc data analysis becomes extremely error-prone.
For those troubled souls stuck with both types of timestamps, this T-SQL may prove useful:
–UTC to Local:
SELECT DATEADD(minute,DATEDIFF(minute,getutcdate(),getdate()), STARTTIME_UTC)
SELECT DATEADD(minute,DATEDIFF(minute,getutcdate(),getdate()),‘2013-03-15 06:19:00pm’)
–Local to UTC:
SELECT DATEADD(minute,DATEDIFF(minute,getdate(),getutcdate()), STARTTIME_LOCAL)
SELECT DATEADD(minute,DATEDIFF(minute,getdate(),getutcdate()),‘2013-03-15 01:19:00pm’)
–Local current time to current UTC time:
SELECT DATEADD(minute,DATEDIFF(minute,getdate(),getutcdate()),GETDATE())
Reference: http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/dacdfe94-d7b9-4063-84b2-5c2aa31fc895/, specifically from poster Kev Riley http://social.msdn.microsoft.com/profile/kev%20riley/?ws=usercard-mini
Also, we are constantly pushed and forced to be razor sharp focused all the time so that you can enjoy the sexual activity without interruption. viagra overnight delivery see these guys On the other hand, this medicine is the alternative medicine of buy cheap sildenafil https://regencygrandenursing.com/post-acute-sub-acute-care/orthopedic-rehab that has come into the market by grasping the hands of the brand medicine as it works adequately in gentle, moderate or extreme Erectile Dysfunction. The disorder which viagra online in india is been discussed here is related to various disorders of the nervous system. Dapoxetine lives up to expectations particularly to postpone the discharge process viagra pfizer cialis and treat untimely discharge.
(*): If you tend toward old-school terminology, you might call this GMT or Greenwich Mean Time.