On Thu, Jun 11, 2009 at 12:02 AM, Peter Eisentraut <pete...@gmx.net> wrote:
> On Wednesday 10 June 2009 17:10:42 Tom Lane wrote: > > 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? > > Random guess for entertainment: Oracle applications do this sort of thing > all > the time. I thought when we are providing the different format into to_char for datetime then standard datetime input converters should also have the capability to read that format. > > > 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. Yes, its we can always use to_date. -- Rushabh Lathia