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

• Re: FM format modifier does not remove leading zero from year at 2010-01-05 15:27:45 from Adrian Klaver

pgsql-hackers by date

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

pgsql-general by date

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