Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get time from Oracle?
Hi,
You are giving the wrong format for minutes (it should me MI not MM, MM is
for
month)
Try TO_CHAR(SYSDATE, 'HH:MI:SS')
AMARENDRA Steve Jelfs wrote:
> Jimmy wrote:
> >
> > 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?
>
> This is, in fact, Oracles solution to the millenium problem. By making
> the clock cycle backwards, developers will have until the year 1900 to
> put things right. At a stroke an additional 96 years of inflated wage
> rates and guaranteed jobs to work on the millenium "time-bomb"!!! ;-)
>
> Sj
-- ***************************************************************** AMARENDRA B NETTEM Oracle Certified DBA (OCP) Whittman-Hart Inc., 311 South Wacker Drive, Suite 3500 Chicago, IL 60606. Residence: ----------- 5039 N E River Road, Apt. 1A NORRIDGE, IL 60656 Ph.No. (708) 583 9870 (H) (312) 913 6758 (W) E-mail:nettama_at_charlie.cns.iit.edu, anettem_at_whittman-hart.com Homepage: http://www.iit.edu/~nettama **************************************************************** Opinions are mine and do not necessarily reflect those of Whittman-hart Inc.Received on Fri Feb 20 1998 - 00:00:00 CST