Converting string with month that is not integer to datetime

Question

I have strings in the format

Mar 25 2013 6:30PM

and I want to convert them to datetime objects in the format

2013-03-25 18:30:00

how would I go about doing this?

http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx – Dinup Kandel Jul 04 '13 at 09:24 — Dinup Kandel, Jul 04 '13 at 09:24

score 3 · Answer 1 · answered Jul 04 '13 at 09:23

3

Try this

DateTime dt
CultureInfo provider = CultureInfo.InvariantCulture;
System.Globalization.DateTimeStyles style = DateTimeStyles.None;
DateTime.TryParseExact("Mar 25 2013 6:30PM", "MMM d yyyy h:mtt", provider, style, out dt);

answered Jul 04 '13 at 09:23

Rajeev Kumar

4,901
8
48
83

-1, pretty sure your format is wrong. At the very least the space before `tt` – musefan Jul 04 '13 at 09:25
1

@musefan i have rectify it. Now working .tested – Rajeev Kumar Jul 04 '13 at 09:26
Yep, I tested your update too. Works well – musefan Jul 04 '13 at 09:29

score 2 · Accepted Answer · answered Jul 04 '13 at 09:28

2

you can use:

 var date = DateTime.Parse("Mar 25 2013 6:30PM");

 Console.WriteLine(date.ToString()); /*This will output the date in the required format */

answered Jul 04 '13 at 09:28

Shai Aharoni

1,955
13
25

Converting string with month that is not integer to datetime

2 Answers2