471,092 Members | 1,013 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

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 1340
802 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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.