Re: how to check db time
Date: Mon, 28 Jan 2008 12:25:47 -0800 (PST)
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?
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 > /
28-JAN-08 03.24.35.046150 PM -05:00 HTH -- Mark D Powell -- Received on Mon Jan 28 2008 - 14:25:47 CST