Horton

Re: [SQL] CURRENT_TIMESTAMP

Manfred Koizar <mkoi-pg@aon.at>

View thread View on postgr.es
From: Manfred Koizar <mkoi-pg@aon.at>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Roland Roberts <roland@astrofoto.org>, pgsql-sql@postgresql.org, pgsql-general@postgresql.org
Date: 2002-09-25T06:54:56Z
Lists: pgsql-hackers, pgsql-general, pgsql-sql 
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