It would be a lot easier for you to have just used a timestamp, it automatically updates itself when a record is modified.
Otherwise you would just update the time field in question when you do your other updates SET timefield = NOW() should work Though using a TIME datatype is not very informative as it only stores the time 00:00:00, and we all know that that time happens once a day, every day for the rest of eternity :) > -----Original Message----- > From: Dermot Paikkos [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 24, 2002 12:46 PM > To: [EMAIL PROTECTED] > Subject: how to update time field with current time? > > > Hi > Probably a silly question but how can I set a time field to > the current > time with update in mysql? > > I have 4 time fields per record. Should I have used set them up as > timestamp? > > Thanx. > Dp. > > ~~ > Dermot Paikkos * [EMAIL PROTECTED] > Network Administrator @ Science Photo Library > Phone: 0207 432 1100 * Fax: 0207 286 8668 > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
