Postgres Pro
Downloads
Home   >   mailing lists

date validation problem - Mailing list pgsql-bugs

From Sh A Guru Prasad
Subject date validation problem
Date
Msg-id 200312291049.hBTAnqmB004131@apsu.ap.nic.in
Whole thread Raw
Responses Re: date validation problem  (Theodore Petrosky <tedpet5@yahoo.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: "Liang, Guang Yu (Lucy)"
Date:
Subject: Re: dyntest.pgc not working in 7.4 ?
Next
From: Theodore Petrosky
Date:
Subject: Re: date validation problem