RE: Convert UTC datetime to LocalTime Zone.

SSC Guru

Points: 1003863

January 12, 2014 at 11:09 am

Sean Lange (9/6/2011)
That will work if all the users are in the same timezone as the server. Otherwise you will have to determine which timezone they are in.
Good point about the half hour. Isn't Newfoundland the only timezone where they do the funky half hour thing? I wonder how confusing time must be as a resident there when so many people forget.

IIRC, they've got some funky stuff with some half hour daylight savings time changes in some of the South Central states of the US.

And, yeah... I realize I responded to a 2 year old post. It still needed to be said.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)