At 08:30 PM 5/24/2004, dleec45 wrote:

>CURRENT_TIMESTAMP worked great, THANKS! LEE

Remember that there is a semantic difference between
'NOW' and CURRENT_TIMESTAMP. 'NOW' produces the time
that the action is taken, so different instances of
'NOW' in a single transaction will produce different
values. CURRENT_TIMESTAMP is constant for the duration
of a transaction.

Regards,


Ann

Or am I having a senior moment???