Correction: Maybe the timestamp is not affected by DST changes *so* they are
accurate when determining the length of time between log entries?

-----Original Message-----
From: Calvin Shafer [mailto:[Email address protected]
Sent: Monday, January 29, 2007 4:10 PM
To: 'LazyDBA Discussion'
Subject: RE: CURRENT_TIMESTAMP vs GETDATE


Maybe the timestamp is not affected by DST changes to they are accurate when
determining the length of time between log entries?

-----Original Message-----
From: Taylor Jay
[mailto:oracledba-ezmlmshield-x40123612.[Email address protected]
Sent: Monday, January 29, 2007 3:18 PM
To: LazyDBA Discussion
Subject: RE: CURRENT_TIMESTAMP vs GETDATE


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






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