Subject | Re: [ib-support] Re:About default values |
---|---|
Author | Claudio Valderrama C. |
Post date | 2001-12-20T02:39Z |
"Aage Johansen" <aagjohan@...> wrote in message
news:4.3.2.7.2.20011218211842.00c1ecf8@127.0.0.1...
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
news:4.3.2.7.2.20011218211842.00c1ecf8@127.0.0.1...
>Yes. Dave Schnepper said that NOW changes while you do a large update,
> Isn't there a Date/Time-thingy that is constant during the transaction?
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