Re: how to check db time

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Mon, 28 Jan 2008 12:25:47 -0800 (PST)
Message-ID: <8962ac73-7460-484b-9d74-87cf47a14b5f@v67g2000hse.googlegroups.com>

On Jan 28, 6:20 am, "news.verizon.net" <kenned..._at_verizon.net> wrote:
> "Talok" <tilokkha..._at_yahoo.com> wrote in message
>
> news:bc50f774-a1f8-420c-bc71-c291b398b4d5_at_l1g2000hsa.googlegroups.com...> Dear all,
>
> > Please let me know how to check the db time at specific
> > moment....let's say i want to check what is the time at db level
> > now....not at OS level using sysdate function.....
>
> > Reply soon.
>
> > Talok Khatri.
>
> The db gets its time from the OS.  I don't understand the question.  What is
> the difference?
> JIm

Here is example code to get the current time from Oracle but as Jim said Oracle gets the date and time from the OS.

UT1 > l
  1 select to_char(sysdate,'YYYYMMDD HH24:MI:SS') DateTime,   2 current_timestamp
  3* from sys.dual
UT1 > /

DATETIME

---

CURRENT_TIMESTAMP

---

20080128 15:24:35
28-JAN-08 03.24.35.046150 PM -05:00 HTH -- Mark D Powell -- Received on Mon Jan 28 2008 - 14:25:47 CST