Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Use of CURRENT_DATE vs SYSDATE and DST
On Mar 22, 2007, at 12:19 PM, Mercadante, Thomas F (LABOR) wrote:
> So after patching my database with the current DST patch (and not
> patching the client), the value of CURRENT_DATE is incorrect – it
> is 15:14 right now. And what the heck does CURRENT_DATE return?
> One hour ahead? I would expect it to be one hour behind (at 14:14)
> until the end of March.
FWIW, in my unpatched 9.2.0.6 instance, these both return the correct
time. Maybe you've found a bug in the DST patch?
janine
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 22 2007 - 15:54:04 CDT
![]() |
![]() |