Take the 2-minute tour ×  I have recently updated my system to
record date/times as UTC as previously they were storing as
local time.  I now need to convert all the local stored
date/times to UTC. I was wondering if there is any built in
function, similar to .NET's ConvertTime method?  I am trying to
avoid having to write a utility app to do this for me.  Any
suggestions?  share|improve this question Are these times all
"local" to you, or are they all different times from multiple
time zones? –  SqlRyan Apr 23 '10 at 18:19 @rwmnau, they are all
local to me. –  James Apr 23 '10 at 20:02 add comment  4 Answers
up vote 5 down vote accepted  If they're all local to you, then
here's the offset:   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?
share|improve this answer Looks the part, will give it a go – 
James Apr 23 '10 at 20:14 I am g