tiota Posted July 13, 2010 Share Posted July 13, 2010 Hi, I need to change time values in mysql db. If I have the following times stored , and I want to change 08:03:00 to 16:03:00 i.e only the first two digits. 08:03:01 09:08:00 010:08:00 011:31:00 00:23:00 05:18:00 03:08:00 Thanks in advance Link to comment https://forums.phpfreaks.com/topic/207550-update-time-stored-in-mysql/ Share on other sites More sharing options...
Pikachu2000 Posted July 13, 2010 Share Posted July 13, 2010 I almost hate to ask, but what is the field's data type? Link to comment https://forums.phpfreaks.com/topic/207550-update-time-stored-in-mysql/#findComment-1085157 Share on other sites More sharing options...
fenway Posted July 13, 2010 Share Posted July 13, 2010 I almost hate to ask, but what is the field's data type? Looks like TIME to me. Link to comment https://forums.phpfreaks.com/topic/207550-update-time-stored-in-mysql/#findComment-1085360 Share on other sites More sharing options...
Pikachu2000 Posted July 13, 2010 Share Posted July 13, 2010 That's what I'm hoping . . . Link to comment https://forums.phpfreaks.com/topic/207550-update-time-stored-in-mysql/#findComment-1085374 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.