Re: date validation problem

I don't see the problem... you are specifying the 66th
day of the 55th month in the year 5555. just a cursory
glance says that 48 months is 4 years... that gives
the year as 5559. try your example with real numbers
(unless these are real)

select to_date('13122003','ddmmyyyy');
  to_date
------------
 2003-12-13
(1 row)

Ted

--- Sh A Guru Prasad <guru@ap.nic.in> wrote:
>
> sir,
>
> in postgresql 7.3.2 when we are trying to query like
>
> select to_date('665555555','ddmmyyyy');
>
> the output is
>
> 5559-09-06
>
> it is not validating the day and month and unknown
> format
> is the output..
>
> any help regarding this is greatful...
>
> thank you
>
>
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/