Re: How to get time from Oracle?

Heheheh! I had this very same problem years ago when I started programming Oracle! I thought I was gonna go nuts!! I just couldn't understand it for the life of me! ;-)

-Mark J. Bobak
Oracle Developer, UMI

In article <887891871.3125.0.nnrp-09.c2de712e_at_news.demon.co.uk>,   "Steve Phelan" <stevep_at_XXnospamXX.toneline.demon.co.uk> wrote:
>
> Er, read the manual.
>
> Try a format mask of 'HH:MI:SS', then you'll get 'minutes' not 'months'.
>
> Steve Phelan.
>
> Jimmy wrote in message <34ECFD3A.2E94_at_comp.polyu.edu.hk>...
> >Hello all,
> >
> > I want to get system time from the Oracle. I use "select
> >to_char(sysdate, 'HH:MM:SS') from dual" in the SQL*PLUS. The first
> >result was "02:02:50". Later, I typed the above command again and the
> >result was "02:02:55". However, when I typed the command a few second
> >later, the result was "02:02:02". Why the system time seems running in
> >cycle? Also, is the sysdate function get time from the UNIX OS? (Oracle
> >is running on UNIX) If I want to change the system time in Oracle, how
> >can I do that?
> >
> >THanks,
> >Jimmy
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Feb 20 1998 - 00:00:00 CST