How to convert a mysql datetime string to c# datetime string?

Question

I get "10/1/15 12:00:00 AM" time string from mysql db. How to convert this to a System.DateTime by the ParseExact method?

Are you sure that you get it as String? And not as already mapped DateTime? — Eugene Podskal
– Eugene Podskal, Commented Mar 13, 2016 at 9:35

Community · Accepted Answer · 2020-07-29 18:28:43Z

2

You can use DateTime.ParseExact method with a custom date and time format.

I assume your 10 is as a day;

var dt = DateTime.ParseExact("10/1/15 12:00:00 AM", "dd/M/yy hh:mm:ss tt", 
                             CultureInfo.InvariantCulture);

By the way, of course saving your DateTime as a string in your database is a bad idea. Change your column type to DATETIME data type if you can.

Read: Bad habits to kick : choosing the wrong data type

edited Jul 29, 2020 at 18:28

CommunityBot

11 silver badge

answered Mar 13, 2016 at 9:37

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

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

Collectives™ on Stack Overflow

How to convert a mysql datetime string to c# datetime string?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related