I get the same results?

select current_timestamp, getdate()

----------------------- -----------------------
2007-01-29 11:25:35.580 2007-01-29 11:25:35.580

(1 row(s) affected)



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


Oracle LazyDBA home page