Datetime problem in Mysql Database

[rajeswari02]

Hi,

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........

[mwasif]

Use MySQL's DATE_FORMAT() to output in the format you like.