RE: SYSDATE and CURRENT

I believe that is correct Carlos. The op system date and sysdate should be the same.

-----Original Message-----
From: Carlos
[mailto:oracledba-ezmlmshield-x7307843.[Email address protected]
Sent: Thursday, February 01, 2007 10:07 AM
To: LazyDBA Discussion
Subject: RE: SYSDATE and CURRENT_DATE

For SYSDATE...when you say that it returns the date and time of local
database,

By local database do you mean operating system???

Thanks so much for your help. All you guys are truly awesome.

"Chris" <oracledba-ezmlmshield-x10845763.[Email address protected]
02/01/2007 12:36 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: SYSDATE and CURRENT_DATE

Again: Session Timezone seems to be the difference.

SYSDATE returns the current date and time. The datatype of the returned
value is DATE. The function requires no arguments. In distributed SQL
statements, this function returns the date and time on your local
database. You cannot use this function in the condition of a CHECK
constraint.

Examples
The following example returns the current date and time:

SELECT TO_CHAR
(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')"NOW"
FROM DUAL;

NOW
-------------------
04-13-2001 09:45:51

CURRENT_DATE returns the current date in the session time zone, in a value
in the Gregorian calendar of datatype DATE.

Examples
The following example illustrates that CURRENT_DATE is sensitive to the
session time zone:

ALTER SESSION SET TIME_ZONE = '-5:0';
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';
SELECT SESSIONTIMEZONE, CURRENT_DATE FROM DUAL;

SESSIONTIMEZONE CURRENT_DATE
--------------- --------------------
-05:00 29-MAY-2000 13:14:03

ALTER SESSION SET TIME_ZONE = '-8:0';
SELECT SESSIONTIMEZONE, CURRENT_DATE FROM DUAL;

SESSIONTIMEZONE CURRENT_DATE
--------------- --------------------
-08:00 29-MAY-2000 10:14:33

-----Original Message-----
From: Carlos
[mailto:oracledba-ezmlmshield-x5043323.[Email address protected]
Sent: Thursday, February 01, 2007 9:16 AM
To: LazyDBA Discussion
Subject: SYSDATE and CURRENT_DATE

Hello Everyone,

Can you please educate me on the diffrences of Sysdate and current_date.
When I select these, they have different values.
Where does each originate their values from???

---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.

Douglas County, Oregon
www.co.douglas.or.us

---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

--
This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

Douglas County, Oregon
www.co.douglas.or.us

Oracle LazyDBA home page