Rick,

R> I notice that NOW is usually later than CURRENT_TIMESTAMP. I believe
R> this has to do with transactions

almost correct. CURRENT_TIMESTAMP is a snapshot taken at the beginning
of a request (statement), while 'NOW' is evaluated at each call.

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================