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