Date Conversion

Question

I have date in this format string strdob =Convert.ToDateTime(ddlDay.SelectedValue + "-" + ddlMonth.SelectedValue + "-" + ddlYear.SelectedValue).ToString("yyyy-MM-dd"); Output is like "2017-03-06" In my database i stored date as {2017-03-06 00:00:00} I used this ,,DateTime DOBDate = DateTime.Parse(strdob ); but the Result Shows like {06-03-2017 00:00:00} I want to display it as {2017-03-06 00:00:00 }.How can i do it??

Piyush Pansuriya · Answer

Hello, Assign date format like: DateTime DOBDate = DateTime.ParseExact(strdob, "yyyy-MM-dd HH:mm:ss" ); Or DateTime DOBDate = System.Convert.ToDateTime(strdob).ToString( "yyyy-MM-dd HH:mm:ss" );

Bharathi Raja · Answer

dateTimePicker1.Format = DateTimePickerFormat.Custom; dateTimePicker1.CustomFormat = "yyyy-MM-dd";

Rafnas T P · Answer

hi, in application by default datetime formate is always shows system datetime format, if you wanted to convert it to any format just use .ToString() method, try as below you will get string datetime in that format, DateTime DOBDate = DateTime.Parse(strdob); string datetime=DOBDate.ToString( "yyyy-MM-dd" ); and this datetime you can show it in read only text box

Rafnas T P · Answer

hi, if you wanted just display then add it to label DateTime DOBDate = DateTime.Parse(strdob); lblnmae.Text=DOBDate.ToString( "yyyy-MM-dd" );

Rafnas T P · Answer

or if you are using datetime picker then try below code dateTimePicker1.Format = DateTimePickerFormat.Custom; dateTimePicker1.CustomFormat = "yyyy-MM-dd";