From owner-freebsd-chat  Mon Sep 30 10: 3:55 2002
Delivered-To: freebsd-chat@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP
	id 1814F37B401; Mon, 30 Sep 2002 10:03:54 -0700 (PDT)
Received: from mail.smashpow.com (mail.smashpow.net [216.235.9.194])
	by mx1.FreeBSD.org (Postfix) with ESMTP
	id C4B7743E42; Mon, 30 Sep 2002 10:03:52 -0700 (PDT)
	(envelope-from drek@smashpow.net)
Received: from mail.smashpow.net (mail.smashpow.net [216.235.9.194])
	by mail.smashpow.com (Postfix) with ESMTP
	id 1E8CA46; Mon, 30 Sep 2002 13:03:51 -0400 (EDT)
Date: Mon, 30 Sep 2002 13:03:51 -0400 (EDT)
From: Agent Drek <drek@smashpow.net>
To: "freebsd-database@freebsd.org" <freebsd-database@freebsd.org>
Cc: "freebsd-chat@freebsd.org" <freebsd-chat@freebsd.org>
Subject: Re: Any Oracle 9 users?  A test please...
In-Reply-To: <3D984877.19685.801EEC30@localhost>
Message-ID: <Pine.BSF.4.44.0209301303030.50384-100000@bang.smashpow.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Sender: owner-freebsd-chat@FreeBSD.ORG
Precedence: bulk
List-ID: <freebsd-chat.FreeBSD.ORG>
List-Archive: <http://docs.freebsd.org/mail/> (Web Archive)
List-Help: <mailto:majordomo@FreeBSD.ORG?subject=help> (List Instructions)
List-Subscribe: <mailto:majordomo@FreeBSD.ORG?subject=subscribe%20freebsd-chat>
List-Unsubscribe: <mailto:majordomo@FreeBSD.ORG?subject=unsubscribe%20freebsd-chat>
X-Loop: FreeBSD.org

On Mon, 30 Sep 2002, Dan Langille wrote:

> Date: Mon, 30 Sep 2002 12:49:59 -0400
> From: Dan Langille <dan@langille.org>
> Reply-To: "freebsd-database@freebsd.org" <freebsd-database@freebsd.org>
> To: "freebsd-database@freebsd.org" <freebsd-database@freebsd.org>
> Cc: "freebsd-chat@freebsd.org" <freebsd-chat@freebsd.org>
> Subject: Any Oracle 9 users?  A test please...
>
> Followups to freebsd-database@freebsd.org please!
>
> Any Oracle 9 users out there?
>
> I need this run:
>
>         BEGIN;
>         SELECT CURRENT_TIMESTAMP;
>         -- wait 5 seconds
>         SELECT CURRENT_TIMESTAMP;
>
> Are those two timestamps the same?
>
> Thanks
>

Our DBA says:

<snip from irc>

<data> SQL> SELECT current_timestamp FROM DUAL;
<data> CURRENT_TIMESTAMP
<data> ---------------------------------------------------------------------------
<data> 30-SEP-02 01.06.42.660969 PM -04:00
<data> SQL> SELECT current_timestamp FROM DUAL;
<data> CURRENT_TIMESTAMP
<data> ---------------------------------------------------------------------------
<data> 30-SEP-02 01.06.48.837372 PM -04:00
<data> (you have to include 'from dual' for 'non-table' selects)

--
   Derek Marshall

Smash and Pow Inc > 'digital plumber'
http://www.smashpow.net


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-chat" in the body of the message