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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Where does SYSDATE come from?

Re: Where does SYSDATE come from?

From: Suresh Easwar <sje_at_sigma-inc.com>
Date: Sat, 25 Apr 1998 13:22:45 -0400
Message-ID: <35421BE4.8BDAB7F8@sigma-inc.com>


On Unix systems, sysdate obtains time from the time( ) system call. On NT, it gets it from GetSystemTime( ) win32 call.

To set time, use the system call directly (on NT it is SetSystemTime( )). Off course, you must have the proper privileges.

Suresh

Kevin Lam wrote:

> Hi,
>
> I wonder the origin of SYSDATE in Oracle! Is it the time of system clock
>
> in bios, in OS or in somewhere else?
>
> BTW, how to change its value?
>
> Thank in advance!
>
> Kevin
Received on Sat Apr 25 1998 - 12:22:45 CDT

Original text of this message

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