Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-01-02 18:41:27
Subject: Re: quoting psql varible as identifier
Previous:From: Pavel StehuleDate: 2010-01-02 18:10:23
Subject: Re: quoting psql varible as identifier

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group