Re: How to get time from Oracle?

> 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?

Your system time is not running in a circle. The MM-Format-String refers to Month (should change every 28 to 31 days :-)

Try MI instead of MM - it should work!
A complete Time-Stamp from Oracle could look like "YYYY-MON-DD HH24:MI:SS"

HTH
Robert Received on Thu Feb 19 1998 - 00:00:00 CET