12 hours - 24 hours adding to database

Asked by Spencer
17 years ago.

Hi Guys, I wander if any of you have had the same problem...

I am using the TimeRangeSelected method and even though I have opted for 24 hour clock it gives me a datetime back of

2007-07-16 01:00:00 PM

^^the above is no good as mySQL database wants it as:

2007-07-16 13:00:00

so whenever iselect time it always loads the appointment to the first half of the day (and unfortunately the office is open from 0700 to 2100...

any ideas?

Thanks

Spencer

asp.net how-to

Comment posted by Dan Letecky
17 years ago.

You can use this code:

string dateString = date.ToString('yyyy-MM-dd HH:mm:ss');

This question is more than 1 months old and has been closed. Please create a new question if you have anything to add.