Re: how to check db time
From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 29 Jan 2008 12:46:29 -0800
Message-ID: <1201639590.618309@bubbleator.drizzle.com>
>
> Databases do not keep time. Get yourself a wrist watch.
>
> --
> Mladen Gogala
> http://mgogala.freehostia.com
Date: Tue, 29 Jan 2008 12:46:29 -0800
Message-ID: <1201639590.618309@bubbleator.drizzle.com>
Mladen Gogala wrote:
> On Sun, 27 Jan 2008 23:10:16 -0800, Talok wrote:
>
>> let's say i want to check what is the time at db level now....not at OS >> level using sysdate function....
>
> Databases do not keep time. Get yourself a wrist watch.
>
> --
> Mladen Gogala
> http://mgogala.freehostia.com
Or reverse engineer from this:
SELECT dbms_asyncrpc_push.get_clock_time FROM dual;
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Jan 29 2008 - 14:46:29 CST