Time Zone Conversion Issue

Question

0.00/5 (No votes)

See more:

VS2010

Hi All,

In my program, i was dealing with 2 DateTime which is the departure time and arrival time of customer at specific airport. These DateTime data will be provided by a travel agent through web service where as there will be only the following data provided:

(Departure Part)
- Date 1
- Time 1
- Country Code 1 (ISO 3166)
(Arrival Part)
- Date 2
- Time 2
- Country Code 2 (ISO 3166)

DateTime 2 have to convert to DateTime 1 where there is no TimeZone or TimeZoneID info provided. Is there any possible way to do this without manually storing all the country code and their corresponding TimeZoneID in database? Is there any function in TimeZoneInfo that can archive this? Or is there any way to retrieve the related timezone by just using the country code?

P.S: Sorry for my bad grammar.

Posted 18-Jan-11 23:00pm

darrell987

Updated 18-Jan-11 23:32pm

Manas Bhardwaj

v4

Add a Solution

Comments

thatraja 19-Jan-11 10:06am

Hi, please use the 'Add comment' link below the answers if you want to clarify the things about that, don't post a answer for that because it won't notify the answerers. Ok
BTW I have moved your message & notified them. please keep continue that way.

3 solutions

Solution 1

You could just store GMT, and let the client app adapt it to local time.

Posted 18-Jan-11 23:21pm

#realJSOP

Comments

thatraja 19-Jan-11 10:04am

[Comment from OP]
Hi John & OriginalGriff,

Yup, i will store the DateTime as GMT in the database. However, the problem is i'm not sure how to convert it into GMT as there are no TimeZone info provided at all. I have to retrieve the TimeZone by using just the country code.

I think TimeZoneInfo.FindSystemTimeZoneById is only usable if we know exactly what is the TimeZoneId, am i right?

Espen Harlinn 19-Jan-11 10:28am

5+ it's a good answer - it's good practice to allways store date & datetime in UTC - not sure why I bother to vote though... it feels like an unappreciated effort :)

Solution 4

Convert it something like this:

C#

DateTime fromDB = new DateTime(1,1,2011,12,0,0);
fromDB.Kind = DateTimeKind.Utc;
DateTime converted = fromDB.DateToLocalTime();

Posted 19-Jan-11 4:08am

#realJSOP

Updated 19-Jan-11 4:09am

v2

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)

OriginalGriff · Accepted Answer · 2011-01-18T23:24:00

Solution 2

Try looking at TimeZoneInfo.FindSystemTimeZoneById: MSDN[^]

Posted 18-Jan-11 23:24pm

OriginalGriff

Comments

thatraja 19-Jan-11 10:05am

[Comment from OP]
Hi John & OriginalGriff,

Yup, i will store the DateTime as GMT in the database. However, the problem is i'm not sure how to convert it into GMT as there are no TimeZone info provided at all. I have to retrieve the TimeZone by using just the country code.

I think TimeZoneInfo.FindSystemTimeZoneById is only usable if we know exactly what is the TimeZoneId, am i right?

OriginalGriff 19-Jan-11 14:23pm

If you look at the example in the link I posted, it refers to:
TimeZoneInfo tst = TimeZoneInfo.FindSystemTimeZoneById("Tokyo Standard Time");
Which implies that the ID should be pretty simple to access via the country ID, no? :laugh: