Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get ORACLE Server Date, not local PC Date?
alesk wrote:
> Hi,
>
> I'm trying to get the server date, but sysdate or any date function
> returns the date of my PC ... is there any way to get this?
>
> Alesk
In addition to Michel's reply:
SYSTIMESTAMP returns the system date, including fractional seconds and time zone, of the system on which the database resides. The return type is TIMESTAMP WITH TIME ZONE.
CURRENT_DATE and CURRENT_TIMESTAMP return DATE and TIMESTAMP WITH TIME ZONE in user's session time zone (set with ALTER SESSION SET TIME_ZONE.) Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Thu Jul 06 2006 - 14:11:30 CDT
![]() |
![]() |