pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Manfred Koizar <mkoi-pg@aon.at>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Roland Roberts <roland@astrofoto.org>
Cc: pgsql-sql@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: [SQL] CURRENT_TIMESTAMP
Date: Wed, 25 Sep 2002 08:54:56 +0200
Message-ID: <cum2puo8d0clhbc5mvs6ju22bai3h2tood@4ax.com> (raw)
In-Reply-To: <200209242156.g8OLuq815295@candle.pha.pa.us>
References: <m2u1kfys7u.fsf@kuiper.rlent.pnet>
	<200209242156.g8OLuq815295@candle.pha.pa.us>

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

view thread (61+ messages)  latest in thread

Message-ID: <cum2puo8d0clhbc5mvs6ju22bai3h2tood@4ax.com>
Permalink:  ../cum2puo8d0clhbc5mvs6ju22bai3h2tood@4ax.com/
Also on:    postgresql.org/message-id/cum2puo8d0clhbc5mvs6ju22bai3h2tood@4ax.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: mkoi-pg@aon.at, pgman@candle.pha.pa.us, roland@astrofoto.org, pgsql-general@postgresql.org
  Subject: Re: [SQL] CURRENT_TIMESTAMP
  In-Reply-To: <cum2puo8d0clhbc5mvs6ju22bai3h2tood@4ax.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox