Format a date string using C#

Question

I have a date that is coming from the database like so:

26/01/2016 12:00:00 AM

and I am capturing it as a string

questionItem.DueDate = dataReader[6].ToString();

I am trying to reformat this string so its looks like

2016-01-26

How would I do this?

What is the actual type of the database column with the date? — Andrew Morton
– Andrew Morton, Commented Jan 26, 2016 at 18:44

Faisal · Accepted Answer · 2016-01-26 18:54:40Z

6

You can specify format like below.

 questionItem.DueDate = Convert.ToDateTime(dataReader[6]).ToString("yyyy-MM-dd");

Check MSDN form DateTime formating.

edited Jan 26, 2016 at 18:54

answered Jan 26, 2016 at 18:45

Faisal

1,4273 gold badges11 silver badges17 bronze badges

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

Comments

Tim · Accepted Answer · 2016-01-26 18:46:47Z

3

Should look something like this

questionItem.DueDate = dataReader[6].ToString("yyyy-MM-dd");

For further readings checkout https://msdn.microsoft.com/en-us/library/az4se3k1(v=vs.110).aspx

edited Jan 26, 2016 at 18:46

Tim

28.6k8 gold badges65 silver badges80 bronze badges

answered Jan 26, 2016 at 18:46

Neil Busse

1499 bronze badges

2 Comments

user979331 Over a year ago

This gives me an error: Error 1 No overload for method 'ToString' takes 1 arguments

Neil Busse Over a year ago

Could you provide the code you are having problems with?

Tyler H · Accepted Answer · 2016-01-26 18:58:56Z

0

Two options:

questionItem.DueDate = new DateTime(dataReader[6]).ToString("yyyy-MM-dd");

Or

questionItem.DueDate = dataReader[6].Split(new string[] { " " }, StringSplitOptions.None)[0].Replace('\\', '-');

answered Jan 26, 2016 at 18:58

Tyler H

4433 silver badges11 bronze badges

Collectives™ on Stack Overflow

Format a date string using C#

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related