c# convert string YYYYMMDDTTTTTT to datetime

Question

I am trying to convert a string date into a format for sql datetime.

The format is like: "20140428132222" I think this equates to YYYYMMDDTTTTTT

Did you even try to search for this before posting a question? — eddie_cat, Apr 28 '14 at 17:39
this works for me like a charm as well `var timestamp = string.Format("{0:yyyy-MM-dd_hh:mm:ss.fff}", DateTime.Now);` — MethodMan, Apr 28 '14 at 18:09

score 1 · Accepted Answer · answered Apr 28 '14 at 17:40

1

 DateTime dt;
 bool valid = DateTime.TryParseExact("20140428132222", "yyyyMMddHHmmss", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt);

gives 4/28/2014 1:22:22 PM

answered Apr 28 '14 at 17:40

Jonesopolis

score 0 · Answer 2 · answered Apr 28 '14 at 17:38

0

answered Apr 28 '14 at 17:38

Martin Costello

score 0 · Answer 3 · answered Apr 28 '14 at 18:16

It's helpful to Read the Documentation:

The various constructor overloads can also be useful. You pick out the various bits, convert them to integer values and use the constructor.

3 Answers3