Get date from DB and format in C#

Question

I am trying to format a date. I get the date from the database in the dateTime format and i want to show only the date part not the time.

 string date = dt.Rows[0]["declaration_date"].ToString();
 string dateFormat = date.ToString("MM/DD/YYYY");

This is not working. Any help?

DateTime date = (DateTime) dt.Rows[0]["declaration_date"]; — Sani Huttunen
– Sani Huttunen, Commented Aug 1, 2018 at 7:47
If declaration_date is a DateTime column you should not convert it to a string. DateTime result = dt.Rows[0].Field<DateTime>("declaration_date"); — Tim Schmelter
– Tim Schmelter, Commented Aug 1, 2018 at 7:47
Your date is already a string, you used 'ToString()' on it already. — Carra
– Carra, Commented Aug 1, 2018 at 7:47

Hans Kilian · Accepted Answer · 2018-08-01 07:53:33Z

2

For date.ToString with formatting to work, date needs to be a DateTime. Try changing your code to something like this:

 DateTime date = (DateTime)dt.Rows[0]["declaration_date"];
 string dateFormat = date.ToString("MM/dd/yyyy");

Also, your formatting string should be MM/dd/yyyy.

answered Aug 1, 2018 at 7:47

Hans Kilian

26.6k4 gold badges39 silver badges56 bronze badges

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

Comments

Semyon Volkov · Accepted Answer · 2018-08-01 07:58:28Z

0

You are doing it almost correctly.

Try this:

string date = dt.Rows[0]["declaration_date"].ToString("MM/dd/yyyy");

The point is that you have to apply .ToString("MM/dd/yy") to a DateTime object, not to a string.

answered Aug 1, 2018 at 7:50

Semyon Volkov

812 silver badges11 bronze badges