By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,641 Members | 2,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,641 IT Pros & Developers. It's quick & easy.

Datetime problem in Mysql Database

P: 8

am developing application in .net,c#.

am saving datetime value as: yyyy-MM-ss HH:mm:ss (24 hour format)
after saving in database i observed in database , it's stored in specified format .

and here the problem is:

when i retrieve data , datetime is coming as 12 hour format.
what to do........
Feb 26 '14 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 801
Use MySQL's DATE_FORMAT() to output in the format you like.
Dec 25 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.