ansaurus

Question

Answer 1

+2 A:

If they're all local to you, then here's the offset:

SELECT GETDATE() AS CurrentTime, GETUTCDATE() AS UTCTime

and you should be able to update all the data using:

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

Would that work, or am I missing another angle of this problem?

rwmnau 2010-04-23 20:05:30

Looks the part, will give it a go

James 2010-04-23 20:14:10

I am getting `Argument data type datetime is invalid for argument 2 of dateadd function.` Any Ideas?

James 2010-04-23 20:16:51

@James: you need to reverse the second and third parameter in the call: `DateTimeStamp = DATEADD(hh, DATEDIFF(hh, GETDATE(), GETUTCDATE()), DateTimeStamp)` -- the second parameter is the interval (the number of hours to add or subtract), and the third is the value to apply that interval to

marc_s 2010-04-23 20:41:08

Spot on @marc_s thanks!!

James 2010-04-23 20:42:32

@James and Marc_s: Crap - I always get those backwards. Marc is correct - it's DATEADD(interval, AmountToAdd, startingDatetime). I've edited the answer.

rwmnau 2010-04-23 20:43:10

ansaurus

tags:

views:

answers:

SQL Server - Convert date field to UTC

related questions