Re: Getting error while trying to insert date with the format 'dd-month-yyyy' , 'day-mm-yyyy' etc..

On Thu, Jun 11, 2009 at 12:02 AM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:

> On Wednesday 10 June 2009 17:10:42 Tom Lane wrote:
> > Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)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