Re: Date rounding problem

From: Syltrem <>
Date: Fri, 05 Apr 2013 17:58:56 -0400
Message-ID: <>

On Fri, 5 Apr 2013 21:24:34 +0100, "Jonathan Lewis" <> wrote:

>"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}')).

Thanks for your reply
Indeed I think you gave a correct explanation

Syltrem Received on Fri Apr 05 2013 - 23:58:56 CEST

Original text of this message