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??

 

Answer 1

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");

Answer 2

dateTimePicker1.Format = DateTimePickerFormat.Custom;

dateTimePicker1.CustomFormat = "yyyy-MM-dd";

Answer 3

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

Answer 4

hi,

 

if you wanted just display then add it to label

DateTime DOBDate = DateTime.Parse(strdob);
lblnmae.Text=DOBDate.ToString("yyyy-MM-dd");

Answer 5

or if you are using datetime picker then try below code

 

dateTimePicker1.Format = DateTimePickerFormat.Custom;

dateTimePicker1.CustomFormat = "yyyy-MM-dd";