Rushabh Lathia writes:
> 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.
to_char is designed to support a near-infinite number of output formats,
including many that ar
On Thu, Jun 11, 2009 at 12:02 AM, Peter Eisentraut wrote:
> On Wednesday 10 June 2009 17:10:42 Tom Lane wrote:
> > Rushabh Lathia writes:
> > > Getting error while trying to insert date with the format
> 'dd-month-'
> > > , 'day-mm-' (format which add the space in between the date ) etc.
On Wednesday 10 June 2009 17:10:42 Tom Lane wrote:
> Rushabh Lathia writes:
> > Getting error while trying to insert date with the format 'dd-month-'
> > , 'day-mm-' (format which add the space in between the date ) etc..
>
> 1. Why are you bothering with the completely pointless to_char c
Rushabh Lathia writes:
> Getting error while trying to insert date with the format 'dd-month-' ,
> 'day-mm-' (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 e
Getting error while trying to insert date with the format 'dd-month-' ,
'day-mm-' (format which add the space in between the date ) etc..
Testcase:
postgres=# \d t
Table "public.t"
Column | Type | Modifiers
+--+---
a | date |
postgres=# insert into