Horton
Menu

FM format modifier does not remove leading zero from year

Andrus <kobruleht2@hot.ee>

View thread
From: "Andrus" <kobruleht2@hot.ee>
To: <pgsql-general@postgresql.org>
Date: 2010-01-02T18:14:07Z
Lists: pgsql-hackers, pgsql-general 
Command:

select to_char(DATE'2009-1-1','FMDD.FMMM.FMYY')

Result observed:

1.1.09

Result expected:

1.1.9

How to fix ?

Andrus.