Re: Date rounding problem

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Fri, 05 Apr 2013 17:58:56 -0400
Message-ID: <euhul8les2dis2iauo52e5ed80nt98ju0q_at_4ax.com>

On Fri, 5 Apr 2013 21:24:34 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>"Syltrem" <syltremzulu_at_videotron.ca> wrote in message
>news:ii8ul8tnjr5ejjf3u96rkbifhgrf4o9pln_at_4ax.com...
>| 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

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