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... Message-ID: <Pine.BSF.4.44.0209301303030.50384-100000@bang.smashpow.net> In-Reply-To: <3D984877.19685.801EEC30@localhost>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.44.0209301303030.50384-100000>