Convert DateTime string to specific timezone DateTime in c#

Question

I have a DateTime string and I know in which timeZone it is formatted but without any timeZone information in that string.

example : 2017-01-19 23:53:57

Now this string will be converted in server which is in another timeZone and I can not change timeZone of server.

If I use DateTime.Parse("2017-01-19 23:53:57"), I get DateTime of server machine's timeZone configuration.

This is my web application and server can be in different timezones.

I don't want to convert Bangladesh time to UTC. I just want to convert DateTime string which is Bangladesh time zone format to DateTime object also in Bangladesh time zone format.

If you know that your DateTime is going to be used in multiple locales, you should be using DateTime.UtcNow whenever possible and doing the conversion to local time only on the end user's computer when necessary. — Abion47
– Abion47, Commented Jan 20, 2017 at 8:34
Better yet, use DateTimeInfo so you don't have to convert between offsets at all — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jan 20, 2017 at 8:43
Define "You know" , is the timezone difference available to the sender machine or you just know it as a developer ?? — Anestis Kivranoglou
– Anestis Kivranoglou, Commented Jan 20, 2017 at 8:46
@Moshii you can't guess the timezone just by looking at the string. Is it local time, UTC or some other offset? WIthout the offset you can ONLY pick between UTC and local. Use a full ISO8601 string instead, including the offset — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jan 20, 2017 at 8:47

Matt Johnson-Pint · Accepted Answer · 2017-01-20 20:57:01Z

5

This should do your work since you know explicitly that the source's time zone is in bagladesh.

var time = DateTime.Parse("2017-01-19 23:53:57");
var clientZone = TimeZoneInfo.FindSystemTimeZoneById("Bangladesh Standard Time");
var utcTime = TimeZoneInfo.ConvertTimeToUtc(time, clientZone);

edited Jan 20, 2017 at 20:57

Matt Johnson-Pint

244k75 gold badges468 silver badges621 bronze badges

answered Jan 20, 2017 at 9:26

Anestis Kivranoglou

8,2545 gold badges47 silver badges48 bronze badges

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

4 Comments

Moshi Over a year ago

wow, it is working, I tested it in one of my servers. But I didn't understand why this is working. Because in this line

var time = DateTime.Parse("2017-01-19 23:53:57");' , time should be converted with machine's TimeZone configuration. Then it is trying to convert

Bangladesh Standard Time' format which should be wrong I guess.

Anestis Kivranoglou Over a year ago

var time = DateTime.Parse("2017-01-19 23:53:57"); Your server parses to its local time zone but He knows that :) .

Matt Johnson-Pint Over a year ago

@Moshii - This converts from Bangladesh time, to UTC. Is that what you wanted? In your question, you didn't say whether it was from something to Bangladesh, or from Bangladesh to something, and you didn't state what that something was either.

Moshi Over a year ago

@MattJohnson I don't want to convert Bangladesh time to UTC. I just want to convert DateTime string which is Bangladesh time zone format to DateTime object also in Bangladesh time zone format.

Mehmet · Accepted Answer · 2017-01-20 08:41:43Z

-2

You can convert 2017-01-19 23:53:57 format string to datetime via below method.

DateTime DateConverter(string date)
    {
        string[] dateAndTimes= date.Split(' ');
        string[] dateParts = dateAndTimes[0].Split('-');
        string convertableString = dateParts[2] + "/" + dateParts[1] + "/" + dateParts[0] + " " + dateAndTimes[1];
        return Convert.ToDateTime(convertableString);
    }

answered Jan 20, 2017 at 8:41

Mehmet

7551 gold badge6 silver badges19 bronze badges

1 Comment

Panagiotis Kanavos Over a year ago

First, that format can be parsed directly with DateTime.Parse. Besides, DateTime.ParseExact can handle any format. Second, the question isn't about parsing at all. It's about converting between timezones.

Collectives™ on Stack Overflow

Convert DateTime string to specific timezone DateTime in c#

2 Answers 2

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related