Thanx to all those how answered:
hcir
walt
William Mussatto
David Yahoo
The answer was now() or
update tab_name set fd_name = (now()) where_expr;
I had tried this but was missing a pair of brackets (honest..)
MYSQL
dp.
~~
Dermot Paikkos * [EMAIL PROTECTED]
Network Administrator @ Science Photo
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
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
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
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
On 2002-07-24 08:46, Dermot Paikkos [EMAIL PROTECTED] wrote:
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?
Now() will update to the current time
Insert