C# convert datetime to custom format

Question

I'm querying a datetime (dd/mm/YYYY hh:mm:ss) value from a database and inserting it in a list like this:

ord.invoiceDate = dt.Rows[i]["invoicedate"].ToString();

How can I convert this string to a custom format like dd-MM-YYYY ? I don't want the hours minutes and seconds.

Answer 1

Try this

ord.invoiceDate = ((DateTime)dt.Rows[i]["invoicedate"]).ToString("dd-MM-yyyy");