Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group