toxi Posted May 17, 2009 Share Posted May 17, 2009 So, I've got two fields of type TIME, but I need them to display the information as follows 1PM displayed as 13:00 2PM as 14:00 etc the problem is I get 2 zero's at the end of the time so it doesn't work for me. Any suggestions on how to change it are welcome, I'm using MySQL v5.1.34 Quote Link to comment Share on other sites More sharing options...
Ken2k7 Posted May 17, 2009 Share Posted May 17, 2009 How can you have 1PM with type TIME? Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted May 17, 2009 Share Posted May 17, 2009 http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_time-format Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.