date validation problem

From: Sh A Guru Prasad <guru(at)ap(dot)nic(dot)in>
To: pgsql-bugs(at)postgresql(dot)org
Subject: date validation problem
Date: 2003-12-29 10:49:52
Message-ID: 200312291049.hBTAnqmB004131@apsu.ap.nic.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Theodore Petrosky 2003-12-29 13:47:56 Re: date validation problem
Previous Message Liang, Guang Yu (Lucy) 2003-12-29 09:51:18 Re: dyntest.pgc not working in 7.4 ?