Re: How to get time from Oracle?

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 Received on Fri Feb 20 1998 - 00:00:00 CST