Re: Getting error while trying to insert date with the format 'dd-month-yyyy' , 'day-mm-yyyy' etc..
| От | Rushabh Lathia |
|---|---|
| Тема | Re: Getting error while trying to insert date with the format 'dd-month-yyyy' , 'day-mm-yyyy' etc.. |
| Дата | |
| Msg-id | 460abcb10906102114u13898a1cxaebc598ef8c88196@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Getting error while trying to insert date with the format 'dd-month-yyyy' , 'day-mm-yyyy' etc.. (Peter Eisentraut <peter_e@gmx.net>) |
| Ответы |
Re: Getting error while trying to insert date with the format 'dd-month-yyyy' , 'day-mm-yyyy' etc..
|
| Список | pgsql-hackers |
On Thu, Jun 11, 2009 at 12:02 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
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.
Yes, its we can always use to_date.
On Wednesday 10 June 2009 17:10:42 Tom Lane wrote:Random guess for entertainment: Oracle applications do this sort of thing all
> Rushabh Lathia <rushabh.lathia@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?
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.
Of course they then also use to_date 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.
Yes, its we can always use to_date.
--
Rushabh Lathia
В списке pgsql-hackers по дате отправления: