On Wednesday 10 June 2009 17:10:42 Tom Lane wrote: > Rushabh Lathia <[email protected]> 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?
Random guess for entertainment: Oracle applications do this sort of thing all the time. > 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. Of course they then also use to_date all the time. -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
