Chris,
I agree that they should have returned the same value. We updated the
Unix box with a patch for the new date for DST. We then did a test via a
qry tool and our applications to make sure everything was working. It
was. We then moved the date on the server to 11-Mar-07 at 01:30. At
02:00 the server properly jumped to 03:00, however at this point the
CURRENT_TIMESTAMP and the GETDATE returned different values. Here in
lies my interest. As stated below "Returns the current date and time.
This function is equivalent to GETDATE.", what makes them equivalent and
not identical? The GETDATE reflected the server time change the
CURRENT_TIMESTAMP did not. Any ideas?

Thanks again.

Cheers-
Jay



-----Original Message-----
From: Chris
[mailto:oracledba-ezmlmshield-x47222144.[Email address protected]
Sent: Monday, January 29, 2007 14:28
To: LazyDBA Discussion
Subject: RE: CURRENT_TIMESTAMP vs GETDATE

From BOL (2005).

"Returns the current date and time. This function is equivalent to
GETDATE."



-----Original Message-----
From: Taylor Jay
[mailto:oracledba-ezmlmshield-x31449968.[Email address protected]
Sent: Monday, January 29, 2007 9:35 AM
To: LazyDBA Discussion
Subject: CURRENT_TIMESTAMP vs GETDATE


Can anyone provide some insight into why these two commands would return
different values. We did some testing of the patches on the new day
light savings time schedule this weekend. During the testing it was
brought to light that these two commands were returning different
values. Formatting aside, they were different. Should these not return
that same data and time?

Thanks in advance for any explanation.

Cheers-
Jay


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