Home > mailing lists

FM format modifier does not remove leading zero from year - Mailing list pgsql-general

From	Andrus
Subject	FM format modifier does not remove leading zero from year
Date	January 4, 2010 07:07:19
Msg-id	B02976BE37F9467D9906E705A8D700AC@andrusnotebook Whole thread Raw
Responses	Re: FM format modifier does not remove leading zero from year
List	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.

From: "Andrus"
Date: 04 January 2010, 07:07:15
Subject: SELECT does not find table created by itself

From: "Andrus"
Date: 04 January 2010, 07:07:39
Subject: Using autogenerated primary key in transaction