Date time issue while handling globally with is daylight

Question

0.00/5 (No votes)

See more:

Suppose we have to save Norwegian time 9:00
If we are ignoring day light.In database in UTC we will save 8:00. In Display we will add +1 for Norway 9:00. In India we are adding +5:30 means 1:30 – it should be 12:30, 1 hour difference

If we consider day light then we should add user +2 for Norway Means in database we will save 7:00 And for Norway for +2 it will be 9:00 And for India it will be 12:30 – correct time. But in this case if we want to see old dates which we have added when day light was false with +1 But now if we show old dates by adding +2 hours. Then it will be 1 hour earlier.

MY Problem

What i am doing is getting local time entered by user.

and converting it to UTC by adding offset hour for user timezone.

And while getting i am passing offset hour for user timezone to SQL and in SQL i am converting UTC date to user local time.

and here the issue comes old dates which i have entered with +1 before 31 march.After 31 march as user offset will be +2 because of day light.So old dates shifted by one hour.

Please correct me where i am doing wrong in handling dates.
And how can i solve my problem

Posted 12-Jun-14 23:31pm

Anuj Banka

Updated 13-Jun-14 17:40pm

v4

Add a Solution

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)

DamithSL · Answer 1 · 2014-06-12T23:38:00

I would save as UniversalTime in the database

C#

var toSaveInDb=    TimeZone.CurrentTimeZone.ToUniversalTime(DateTime.Now)

then any country you can get it back as below

C#

var fromDBtoUI  =  TimeZone.CurrentTimeZone.ToLocalTime(myUtcDateTime)

references
http://msdn.microsoft.com/en-us/library/system.datetime.touniversaltime.aspx[^]
How to get UTC equivalent for my local time in C#[^]
You need to detect client culture and set it as current thread culture.
http://weblog.west-wind.com/posts/2014/Mar/27/Auto-Selecting-Cultures-for-Localization-in-ASPNET[^]