> Rick Debay wrote:
> > I notice that NOW is usually later than CURRENT_TIMESTAMP. I believe
> > this has to do with transactions, but I'd like an explanation.
> >
>
> NOW is the time at the instant it is evaluated. CURRENT_TIMESTAMP
> is fixed for the duration of a statement. In other words, if you
> were to update every record in a large table, setting TIME_MODIFIED
> to NOW, you'd see several different times. CURRENT_TIMESTAMP, on
> the other hand, would set the TIME_MODIFIED to the same value.

That being said, CURRENT_TIMESTAMP is SQL standard.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com