From owner-freebsd-database Mon Sep 30 10: 3:55 2002 Delivered-To: freebsd-database@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 To: "freebsd-database@freebsd.org" Cc: "freebsd-chat@freebsd.org" Subject: Re: Any Oracle 9 users? A test please... In-Reply-To: <3D984877.19685.801EEC30@localhost> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Mon, 30 Sep 2002, Dan Langille wrote: > Date: Mon, 30 Sep 2002 12:49:59 -0400 > From: Dan Langille > Reply-To: "freebsd-database@freebsd.org" > To: "freebsd-database@freebsd.org" > Cc: "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: SQL> SELECT current_timestamp FROM DUAL; CURRENT_TIMESTAMP --------------------------------------------------------------------------- 30-SEP-02 01.06.42.660969 PM -04:00 SQL> SELECT current_timestamp FROM DUAL; CURRENT_TIMESTAMP --------------------------------------------------------------------------- 30-SEP-02 01.06.48.837372 PM -04:00 (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-database" in the body of the message