Re: to_date() month translation

On Fri, Jun 15, 2001 at 04:51:26PM -0400, pgsql-bugs(at)postgresql(dot)org wrote:

> Sample 1:
> ---------
>
> template1=# select to_date('12-January-2001','DD-Month-YYYY');
> to_date
> ------------
> 0001-01-12
> (1 row)
>
> template1=# select to_date('12-January -2001','DD-Month-YYYY');
> to_date
> ------------
> 2001-01-12
> (1 row)
>
> No file was uploaded with this report

What is bad on the PostgreSQL documentation and mailing list archives?!

The month name string is 9-chars or you must use FM (fill-mode)option:

test=# select to_char(now(), 'Month DD');
to_char
--------------
June 18
(1 row)

test=# select to_char(now(), 'FMMonth DD');
to_char
---------
June 18
(1 row)

test=# select to_date('12-January-2001','DD-FMMonth-YYYY');
to_date
------------
2001-01-12
(1 row)

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