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 Quote 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? Quote 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. Quote 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 . . . Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.