RE: Convert UTC datetime to LocalTime Zone.

SSC Guru

Points: 323504

September 6, 2011 at 1:17 pm

yeah i should have thought like you did about end-user timezone isntead of server timezone.

i did a bit of research, and there's a lot of places that are on half hour differences many near indea and the mideast....Nepal is actually off by 15 minutes from it's neighbor Bangladesh.

Iran, India, some parts of Australia, Newfoundland and more are off by half hours:

http://geography.about.com/od/culturalgeography/a/offsettimezones.htm

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!