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