Rushabh Lathia <rushabh.lat...@gmail.com> writes: > 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..
1. Why are you bothering with the completely pointless to_char call at all? 2. It is not a bug that to_char is capable of emitting formats that won't be read by the standard datetime input converter. If you insist on making a useless conversion to char and back, it's on your head to choose a format setting that will work. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers