How to update data in sql server from local to universal time

Question

I have stored date time in local time and I need to convert them all to Universal time.

How to do this in SQL Server 2008?

In local time, I mean either BST or GMT.

i.e. I kept DateTime.Now() from .NET for a year, and now I need to homogenize the data.

Thanks!

Answer 1

consider sending already with c # utc

also exists SELECT GETUTCDATE()

in sql server

http://msdn.microsoft.com/en-us/library/ms178635.aspx

change

if you need to update it

 UPDATE SomeTable SET DateTimeStamp = DATEADD(hh, DATEDIFF(hh, GETDATE(), GETUTCDATE()), DateTimeStamp) 

Answer 2

Use the DATEADD function of SQL Server. You just have to know what not. time difference from your local time to UTC.