Re: to_date bug

On Wed, Jun 12, 2002 at 10:54:53AM -0600, Jeff wrote:
>
> select to_date('December 12 2002','Month dd yyyy');
> to_date
> ------------
> 2002-12-02
>
> select to_date('January 12 2002','Month dd yyyy');
> to_date
> ------------
> 0005-06-24 <----- Problem right there.

Please, see docs...

test=# select to_date('January 12 2002','Month dd yyyy');
^^
to_date
------------
2002-01-12

test=# select to_date('January 12 2002','FMMonth dd yyyy');
^^
to_date
------------
2002-01-12

I try prepare it more robus for 7.3.

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz