Featured post
c# - How can I convert a date from the format "dd/mm/yyyy" to "yyyy/dd/mm"? -
i have textbox in user supposed enter date in format dd/mm/yyyy
, date stored yyyy/mm/dd
in database.
so want user enter date in dd/mm/yyyy
format , later want convert yyyy/mm/dd
can query database.
how can convert user input date dd/mm/yyyy
yyyy/mm/dd
?
quick , maybe dirty:
string reformatteddate = datetime.parseexact(textbox1.text, "dd/mm/yyyy", null).tostring("yyyy/mm/dd");
this, of course, assumes content of textbox in assumed format, should checks in before ensure that. there's safer way not need additional checks:
datetime result; if(datetime.tryparseexact(textbox1.text, "dd/mm/yyyy", null, system.globalization.datetimestyles.none, out result) { // here can safely use result string reformatteddate = result.tostring("yyyy/mm/dd"); } else { // screw user }
this try parse content of textbox , return via out result
, if successful, return true. otherwise can rest assured input either not in assumed format, or not valid date.
please aware parseexact
throw argumentnullexception
or argumentexception
if conversion fails.
i have text box in user supposed enter date in dd/mm/yyyy format, date stored yyyy/mm/dd in database.
the obvious answer is: use datetimepicker , parameterized query before wrestling string conversion. save a lot of headache in long run.
- Get link
- X
- Other Apps
Comments
Post a Comment