Re: to_date function

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Wed, 07 Nov 2001 17:49:03 GMT
Message-ID: <3be973b4.71293093@news.alt.net>

On Wed, 7 Nov 2001 11:35:19 -0600, "SG" <sajnish_gupta_at_yahoo.com> wrote:

>I am not sure what I am doing wrong, but when I run this query:
>
>SQL> select to_date(11051946, 'MM-DD-YYYY') from dual;
>TO_DATE(11051946,'MM
>
>--------------------
>
>05-NOV-46
>
>But, when I change the number 11051946 to 11451946, I get an error:
>
>SQL> select to_date(11451946, 'MM-DD-YYYY') from dual;
>
>TO_DATE(11451946,'MM
>
>--------------------
>
>ORA-01861: literal does not match format string
>
>Any ideas?
>thanks for the help
>SG

11451946, 'MM-DD-YYYY') Is

MM     = 11
DD     = 45

YYYY = 1946 DD can never be greater then the amount of days for MM/YYYY.

B. Received on Wed Nov 07 2001 - 11:49:03 CST