Hi Brandon, first of all, it is my absolute pleas...

2009-07-09T06:19:10.784+05:30

Hi Brandon,

first of all, it is my absolute pleasure that almighty of SQLServerNation and MVP in queue left me comment, thank you very much for that. I will surely work on your very positive comment.

In you're code: declare @dt datetime set @dt...

2009-07-09T00:23:37.878+05:30

In you're code:

declare @dt datetime

set @dt='9/22/2009 1:25:00 PM'

select DATEADD(hh,datediff(hh,GETDATE(),getUTCdate()),@dt) as 'UTC DateTime'

You are using the current offset of GETDATE() and GETDATEUTC() to account for local time shift. What about for locale's that observe daylight savings time. Your calculation will incorrectly calculate the local time for values that are not in the same phase of daylight savings time. Other than that, looks good.

BrandonGalderisi

Comments on SQL-Server Blog of Ritesh Shah --Fight the fear of SQL with SQLHub.com: Convert local DateTime to UTC DateTime in SQL Serv...

Hi Brandon, first of all, it is my absolute pleas...

In you're code: declare @dt datetime set @dt...