Search Postgresql Archives

FM format modifier does not remove leading zero from year

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: <pgsql-general@xxxxxxxxxxxxxx>
Subject: FM format modifier does not remove leading zero from year
From: "Andrus" <kobruleht2@xxxxxx>
Date: Sat, 2 Jan 2010 20:14:07 +0200

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.

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: FM format modifier does not remove leading zero from year
  - From: Adrian Klaver

Prev by Date: SELECT does not find table created by itself
Next by Date: Using autogenerated primary key in transaction
Previous by thread: SELECT does not find table created by itself
Next by thread: Re: FM format modifier does not remove leading zero from year
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux