RE: SYSDATE and CURRENT

There is also something I find very useful in testing called FIXED_DATE
This allows you to set sysdate to be a fixed value
set using an initialization parameter or alter system in later versions

-----Original Message-----
From: Chris
[mailto:oracledba-ezmlmshield-x78145206.[Email address protected]
Sent: 01 February 2007 18:52
To: LazyDBA Discussion
Subject: RE: SYSDATE and CURRENT_DATE

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

---------------------------------------------------------------------
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

Oracle LazyDBA home page