Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get time from Oracle?

Re: How to get time from Oracle?

From: Yves Raymaekers <yves.raymaekers_at_advalvas.be>
Date: 1998/02/19
Message-ID: <34ECA2F8.4C17614C@advalvas.be>#1/1

MM stands for month, use MI for minutes

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? 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
Received on Thu Feb 19 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US