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 Link to comment https://forums.phpfreaks.com/topic/158451-modifying-mysqls-time-format/ 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? Link to comment https://forums.phpfreaks.com/topic/158451-modifying-mysqls-time-format/#findComment-835691 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 Link to comment https://forums.phpfreaks.com/topic/158451-modifying-mysqls-time-format/#findComment-835729 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.