C# string to DateTime with timezone

Question

I want to format the string : "2012-04-20 10:10:00+0200" to a dateTime with this format. so I think it must be "yyyy-MM-dd hh:mm:ss zzz"?

when I tried this

   // starttime =  {20/04/2012 10:10:00} without my +0200!
DateTime starttime = Convert.ToDateTime("2012-04-20 10:10:00+0200",CultureInfo.CurrentCulture);
// And this gave me a format exception : {System.FormatException: String was not recognized as a valid DateTime.
        DateTime result = DateTime.ParseExact("2012-04-20 10:10:00+0200", "yyyy-MM-dd hh:mm:ss zzz", CultureInfo.InvariantCulture);

SOLUTION GIVEN BY "V4Vendetta" :

You should try using DateTimeOffset instead of the DateTime

DateTimeOffset result = DateTimeOffset.Parse("2012-04-20 10:10:00+0200",CultureInfo.InvariantCulture);

Here you get the Offset (2 hrs) too which could be computed with your DateTime (10:10) value and get your desired out put (result.DateTime + result.Offset)

As per my knowledge your input should be "2012-04-20 10:10:00+02:00" — Ramesh
– Ramesh, Commented Apr 24, 2012 at 7:23
@user1264255 Yes, it will help you on your feature questions ;). — chaliasos
– chaliasos, Commented Apr 24, 2012 at 8:58
Useful MSDN link for roundtripping dates/times in .NET msdn.microsoft.com/en-us/library/bb882584(v=vs.110).aspx — Luke Puplett
– Luke Puplett, Commented Oct 12, 2015 at 11:50

V4Vendetta · Accepted Answer · 2012-04-24 07:40:57Z

33

You should try using DateTimeOffset instead of the DateTime

DateTimeOffset result = DateTimeOffset.Parse("2012-04-20 10:10:00+0200",CultureInfo.InvariantCulture);

Here you get the Offset (2 hrs) too which could be computed with your DateTime (10:10) value and get your desired out put (result.DateTime + result.Offset)

edited Apr 24, 2012 at 7:40

answered Apr 24, 2012 at 7:34

V4Vendetta

38.5k9 gold badges83 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

V4Vendetta Over a year ago

Glad ! you should attempt to mark as answers for all your questions which helped you and encourage others.

Keerigan Over a year ago

Such a useful thing to have!

Red Bit · Accepted Answer · 2012-04-24 07:23:38Z

2

use "2012-04-20 10:10:00 +02:00" instead of " "2012-04-20 10:10:00+0200"

answered Apr 24, 2012 at 7:23

Red Bit

4852 gold badges7 silver badges16 bronze badges

3 Comments

user1264255 Over a year ago

then i got the same when i just convert to datetime. result : // starttime = {20/04/2012 10:10:00} without my +0200

Red Bit Over a year ago

It should be in +02:00 time zone already. Please check by toString("yyyy-MM-dd hh:mm:ss zzz")

user1264255 Over a year ago

That's right, but i realy needed it in DateTime. V4Vendetta has given me the right solution. But still Thanks for your help :)

Bhargav · Accepted Answer · 2012-04-24 07:22:40Z

1

The MSDN article here seems to have exactly what you're looking for. Per said article, you should be using {0:MM/dd/yy H:mm:ss zzz}

answered Apr 24, 2012 at 7:22

Bhargav

10.2k1 gold badge21 silver badges29 bronze badges

Comments

HW90 · Accepted Answer · 2012-04-24 07:24:15Z

-1

Try this:

DateTime datetime = DateTime.ParseExact("10/10/2009 12:00:00", "MM/dd/yyyy hh:mm:ss", System.Globalization.CultureInfo.CurrentCulture);

answered Apr 24, 2012 at 7:24

HW90

1,9932 gold badges22 silver badges45 bronze badges

1 Comment

jcaruso Over a year ago

This does not do anything for timezone.

Collectives™ on Stack Overflow

C# string to DateTime with timezone

4 Answers 4

2 Comments

3 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

3 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related