Get error when Convert string to datetime in C#

Question

How to convert string: "14/07/2018 14:00:00 ق.ظ" to datetime ?

I am using Convert.ToDateTime() and

DateTime dt = DateTime.ParseExact("14/07/2018 14:00:00 ق.ظ", 
    "dd/MM/yyyy", CultureInfo.InvariantCulture);

I got an exception

String was not recognized as a valid DateTime

Your second argument must match the string with the date to parse, it's obviously not the case here. Add the missing part. — AFract, Jul 02 '18 at 06:40
Possible duplicate of [Converting a String to DateTime](https://stackoverflow.com/questions/919244/converting-a-string-to-datetime) — Mohammad Javad Noori, Jul 02 '18 at 06:40

Karan · Accepted Answer · 2018-07-02T06:51:40.263

4

In DateTime.ParseExact second parameter format need to match exactly as per string you are passing.

DateTime dt = DateTime.ParseExact("14/07/2018 14:00:00 ق.ظ", "dd/MM/yyyy HH:mm:ss ق.ظ", CultureInfo.InvariantCulture);

If you want only date part then add .Date at the end as below.

DateTime dt = DateTime.ParseExact("14/07/2018 14:00:00 ق.ظ", "dd/MM/yyyy HH:mm:ss ق.ظ", CultureInfo.InvariantCulture).Date;

Try it online!

edited Jul 02 '18 at 06:51

answered Jul 02 '18 at 06:47

Karan

12,059
3
24
40

I think it is a nice solution if you want everything – aloisdg Jul 02 '18 at 06:49
2

If you want only date then just add `.Date` at the end. – Karan Jul 02 '18 at 06:50

score 2 · Answer 2 · answered Jul 02 '18 at 06:44

A quick and dirty solution would be to clean the date ahead. Something like this would work:

var date = "14/07/2018 14:00:00 ق.ظ";
DateTime dt=DateTime.ParseExact(date.Remove(date.IndexOf(" ")), "dd/MM/yyyy", CultureInfo.InvariantCulture);

Console.WriteLine(dt.Day);
Console.WriteLine(dt.Month);
Console.WriteLine(dt.Year);

Output

14
7
2018

Try it online!

Get error when Convert string to datetime in C#

2 Answers2