FM format modifier does not remove leading zero from year

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: FM format modifier does not remove leading zero from year
Date: 2010-01-02 18:14:07
Message-ID: B02976BE37F9467D9906E705A8D700AC@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-01-02 18:23:24 Re: set-level update fails with unique constraint violation
Previous Message Andrus 2010-01-02 16:46:40 SELECT does not find table created by itself

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-01-02 18:41:27 Re: quoting psql varible as identifier
Previous Message Pavel Stehule 2010-01-02 18:10:23 Re: quoting psql varible as identifier