Subject Re: [ib-support] Re:About default values
Author Claudio Valderrama C.
"Aage Johansen" <aagjohan@...> wrote in message
news:4.3.2.7.2.20011218211842.00c1ecf8@127.0.0.1...
>
> Isn't there a Date/Time-thingy that is constant during the transaction?

Yes. Dave Schnepper said that NOW changes while you do a large update,
whereas CURRENT_TIME and CURRENT_TIMESTAMP remain the same for all the rows
touched in a single statement:

update tbl set t_field = CURRENT_TIMESTAMP;

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing