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 ORACLE Server Date, not local PC Date?

Re: How to get ORACLE Server Date, not local PC Date?

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 6 Jul 2006 12:11:30 -0700
Message-ID: <1152213090.454266.120180@k73g2000cwa.googlegroups.com>

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

Original text of this message

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