William R. Mussatto wrote:
>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.
>
You can have more than one timestamp.
They are all updated on an insert, but
only the first will be updated with an update
>
>
>>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
