Subject | Updating a timestamp field |
---|---|
Author | tickerboo2002 |
Post date | 2002-10-31T12:35:05Z |
I have a table with two timestamps
TIMESTAMP_ADDED TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
TIMESTAMP_SENT TIMESTAMP
When I update the TIMESTAMP_SENT field, I'd like to use the time on
the server, rather than passing in the (possibly incorrect)client's
time/date.
Can I do something like this:
UPDATE myTable(TIMESTAMP_SENT)
VALUES( NOW() )
or, would I have to do this as a SP in order to get the server time?
TIA
David
FBv1, BCB5, IBOv4.2
TIMESTAMP_ADDED TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
TIMESTAMP_SENT TIMESTAMP
When I update the TIMESTAMP_SENT field, I'd like to use the time on
the server, rather than passing in the (possibly incorrect)client's
time/date.
Can I do something like this:
UPDATE myTable(TIMESTAMP_SENT)
VALUES( NOW() )
or, would I have to do this as a SP in order to get the server time?
TIA
David
FBv1, BCB5, IBOv4.2