Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6EE9B475E14 for ; Wed, 25 Sep 2002 02:53:02 -0400 (EDT) Received: from email03.aon.at (WARSL402PIP6.highway.telekom.at [195.3.96.93]) by postgresql.org (Postfix) with SMTP id 436CD475DD0 for ; Wed, 25 Sep 2002 02:53:01 -0400 (EDT) Received: (qmail 376538 invoked from network); 25 Sep 2002 06:53:01 -0000 Received: from m152p024.dipool.highway.telekom.at (HELO cantor) ([62.46.8.248]) (envelope-sender ) by qmail3rs.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 25 Sep 2002 06:53:01 -0000 From: Manfred Koizar To: Bruce Momjian Cc: Roland Roberts , pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: [SQL] CURRENT_TIMESTAMP Date: Wed, 25 Sep 2002 08:54:56 +0200 Message-ID: References: <200209242156.g8OLuq815295@candle.pha.pa.us> In-Reply-To: <200209242156.g8OLuq815295@candle.pha.pa.us> X-Mailer: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/1100 X-Sequence-Number: 30681 On Tue, 24 Sep 2002 17:56:51 -0400 (EDT), Bruce Momjian 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