> 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() )

UPDATE myTable SET TIMESTAMP_SENT = CURRENT_TIMESTAMP;

But with the above, you will update all records in myTable.


Regards,
Thomas Steinmaurer
IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com