From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
Cc: | Roland Roberts <roland(at)astrofoto(dot)org>, pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [SQL] CURRENT_TIMESTAMP |
Date: | 2002-09-29 03:28:03 |
Message-ID: | 200209290328.g8T3S3S17164@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-sql |
OK, we have two db's returning statement start time, and Oracle 8 not
having CURRENT_TIMESTAMP.
Have we agreed to make CURRENT_TIMESTAMP statement start, and now()
transaction start? Is this an open item or TODO item?
---------------------------------------------------------------------------
Manfred Koizar wrote:
> On Tue, 24 Sep 2002 17:56:51 -0400 (EDT), Bruce Momjian
> <pgman(at)candle(dot)pha(dot)pa(dot)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
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2002-09-29 03:47:06 | Re: [SQL] CURRENT_TIMESTAMP |
Previous Message | Gerhard Häring | 2002-09-29 02:39:49 | Re: list of error code |
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2002-09-29 03:47:06 | Re: [SQL] CURRENT_TIMESTAMP |
Previous Message | Bruce Momjian | 2002-09-29 03:27:00 | Re: NUMERIC's transcendental functions |
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2002-09-29 03:47:06 | Re: [SQL] CURRENT_TIMESTAMP |
Previous Message | Andrew G. Hammond | 2002-09-29 03:08:49 | Re: SQL formatter? |