On Wed, 24 Jul 2002, Dermot Paikkos wrote: > Date: Wed, 24 Jul 2002 17:46:00 +0100 > From: Dermot Paikkos <[EMAIL PROTECTED]> > 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?
the function NOW(). Note you can have only one "TimeStamp" field in a table (i.e., one which will be automatically updated). The other ones should be datetime fields to avoid confusion. > > 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 > Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 --------------------------------------------------------------------- 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