Subject Updating a timestamp field
Author tickerboo2002
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