468,512 Members | 1,500 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,512 developers. It's quick & easy.

Datetime problem in Mysql Database


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
1 1288
801 Expert 512MB
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.

Similar topics

4 posts views Thread by Dave Moore | last post: by
reply views Thread by mdh | last post: by
12 posts views Thread by mistral | last post: by
1 post views Thread by mosesdinakaran | last post: by
2 posts views Thread by Julian Evans | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.