Getting error while trying to insert date with the format 'dd-month-yyyy' , 'day-mm-yyyy' (format which add the space
inbetween the date ) etc.. <br /><br />Testcase:<br />========<br />postgres=# \d t<br /> Table "public.t"<br />
Column| Type | Modifiers <br />--------+------+-----------<br /> a | date | <br /><br />postgres=# insert into t
values( to_char(current_date+2, 'day-mm-yyyy')::date); <br />ERROR: invalid input syntax for type date: "friday
-06-2009"<br/><br />postgres=# insert into t values ( to_char(current_date+2, 'dd-month-yyyy')::date);<br />ERROR:
invalidinput syntax for type date: "12-june -2009"<br /><br clear="all" /><br />Debugged the issue and found that
errorcoming from date_in() -> DecodeDateTime(). Problem here is whenever any space comes in the date ParseDateTime()
unableto break string into tokens based on a date/time context.<br /><br /><br />-- <br />Rushabh Lathia<br /><a
href="http://www.EnterpriseDB.com">www.EnterpriseDB.com</a><br/>