Re: Date rounding problem

From: Jonathan Lewis <>
Date: Fri, 5 Apr 2013 21:24:34 +0100
Message-ID: <>

"Syltrem" <> wrote in message
| Oops - I forgot to mention something important
| The problem only appears when I do to_date(sysdate) which I know is
| stupid, but it comes from a procedure I was trying to run when I found
| out it wouldn't run in certain databases.

I think your observations make sense when you consider that to_date(sysdate) means to_date(to_char(sysdate)), which means to_date(to_char(sysdate,'dd-MON-yyyyy')) until you set the nls_date_format, and then it means to_date(to_char(sysdate,'{your nls_date_format}')).



Jonathan Lewis

Author: Oracle Core (Apress 2011)
Received on Fri Apr 05 2013 - 22:24:34 CEST

Original text of this message