How to convert UTC Date to Local Time

Question

1.00/5 (1 vote)

See more:

Hello Guys,

I am stumble in the scenario where i need to convert UTC DateTime stored in the database to local time once the user retrieved the data and rendered in their respective browsers.

My current solution is: to get the timezone of the current user and store in session and use that to convert the utc to local time.

current problem: the timezone of the current user might vary for daylight saving. and for scenario where the timezone of the current user is in daylight saving mode but the date to convert is in regular time.

scenario:
1. user saved data on regular time
2. during daylight saving user open the app and retrieved data
3. when converting the datetime the timezone that will be use is daylight saving

Question:
1. What is the best approach to handle datetime conversion from utc to local time where daylight saving is also considered?
2. Is there a way to determine if the utc is in daylight or ordinary time?

Posted 26-Feb-13 19:51pm

Jephunneh Malazarte

Updated 26-Feb-13 21:07pm

v3

Add a Solution

Comments

Sergey Alexandrovich Kryukov 27-Feb-13 2:14am

By reading documentation. How can it possibly be a problem? What did you try so far?
—SA

Jephunneh Malazarte 27-Feb-13 2:21am

because the data that was saved was in ordinary time (GMT-5). Now the locale timezone of the user is in day light saving time (GMT-4). so when i use that to convert the time the result will be 1 hr diff.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Accepted Answer · 2013-02-26T23:32:00

Solution 1

See http://www.w3schools.com/jsref/jsref_gettimezoneoffset.asp[^].

Posted 26-Feb-13 23:32pm

Richard MacCutchan

Comments

Jephunneh Malazarte 7-Mar-13 21:18pm

thanks, i'll accept your solution because this is indeed part of the solution but not the exact one though. The problem is a bit complicated than a mere conversion of UTC to Local DateTime.

Richard MacCutchan 8-Mar-13 3:49am

But it is the exact solution. Whenever you are storing datetime values in a database or other permanent storage, you must always store the UTC value of that time. Then at some later time when you wish to display it, you convert it back to its local time value. In that way it will always be correct and adjusted for daylight savings: that is assuming you use the correct conversion routines.