Re: [SQL] CURRENT_TIMESTAMP

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