Re: help on to_date conversion please.... - Mailing list pgsql-admin

Thanks.  That seems a better way to go.

At 03:47 PM 4/3/02 -0800, Stephan Szabo wrote:

>On Wed, 3 Apr 2002, Chris Pesko wrote:
>
> > Never mind.  Just figured it out.  Need to grab the substring from 2 for 8
> > from the to_char result because it holds character number 1 reserv ed for +
> > or - signs.  + is default or white space.  I think that is the reason.  Any
> > other input?????
>
>You might want to try the FM format on the to_char string...
>sszabo=#  select to_date(to_char(20020101, 'FM99999999'),'yyyymmdd');
>   to_date
>------------
>  2002-01-01
>(1 row)