Re: [SQL] [GENERAL] CURRENT_TIMESTAMP

[Manfred Koizar]

On Tue, 24 Sep 2002 17:56:51 -0400 (EDT), Bruce Momjian
<[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster