Convert datetime2 to string(“dd/MM/yyyy”)

Question

i have a datetime2 column in the database.I'm trying to fetch that from database and I want to display it in the view as string. i tried: dt.ToString("dd/MM/yyyy"); But it gave an error.

Nitin Sontakke · Answer

Going forward, please remember that whenever you say "But it gave an error", why not just paste the error here itself. It is hugely helpful for anyone attempting to help you.

Vinay Singh · Answer

Hi Try the below link http://www.csharp-examples.net/string-format-datetime/

Rajeesh Menoth · Answer

Hi, Try this code : DateTime pmdate = (DateTime) dt.Rows[0][ "Datetimecolumn_name" ]; lblDate.Text = pmdate.ToString( "dd/MM/yyyy" ); Reference : http://stackoverflow.com/questions/29266142/converting-a-datetime-from-the-datatable-to-a-specific-format-of-string-c-sharp

Suthahar Jegatheesan · Answer

Hi Siva, I am assuming, you are trying to access data like this dt.Rows[index][“Colname”].T oString("dd/MM/yyyy"); dt.rows[index].[ColumnName] column is DateTime in database vardatevalue=(DateTime)dt.Rows[i][ "yourdatecolumn" ] .ToString( "dd/MM/yyyy" ,CultureInfo.InvariantCulture); dt.rows[index]. dt[ColumnName] column is String in Database vardatevalue=DateTime.ParseExact(dt.Rows[i][ "yourdatecolumn" ].ToString(), "dd-MM-yyyyhh:mm:sstt" , CultureInfo.InvariantCulture) .ToString( "dd/MM/yyyy" ,CultureInfo.InvariantCulture);

ketan borsdiya · Answer

Hi Siva, You are converting Datatable thats why you giver error. You need to convert column value like dt.Row[0]["ColumnName"].ToString("dd/MM/yyyy") ;

Convert datetime2 to string(“dd/MM/yyyy”)

Answers (5)