On Tue, 24 Sep 2002 17:56:51 -0400 (EDT), Bruce Momjian
<pgman@candle.pha.pa.us> wrote:
>Can you run a test:
>
> BEGIN;
> SELECT CURRENT_TIMESTAMP;
> wait 5 seconds
> SELECT CURRENT_TIMESTAMP;
>
>Are the two times the same?
MS SQL 7:
begin transaction
insert into tst values (CURRENT_TIMESTAMP)
-- wait
insert into tst values (CURRENT_TIMESTAMP)
commit
select * from tst
t
---------------------------
2002-09-24 09:49:58.777
2002-09-24 09:50:14.100
Interbase 6:
SQL> select current_timestamp from rdb$database;
=========================
2002-09-24 22:30:13.0000
SQL> select current_timestamp from rdb$database;
=========================
2002-09-24 22:30:18.0000
SQL> commit;
Servus
Manfred