FM suffix in to_char Y/YY/YYY still screwy

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: FM suffix in to_char Y/YY/YYY still screwy
Date: 2010-04-07 20:46:14
Message-ID: 21721.1270673174@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I thought we'd fixed this ...

regression=# select to_char('2009-01-01'::date, 'YY');
to_char
---------
09
(1 row)

regression=# select to_char('2009-01-01'::date, 'FMYY');
to_char
---------
09
(1 row)

Not a lot of zero suppression happening there :-(.

I believe the correct fix is to reduce the year mod 100 (or 10 or 1000)
before feeding it to snprintf, rather than playing games with printing
only part of the result string as the original and current code try to
do.

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2010-04-07 23:39:52 Re: Enhancing phonetic search support for more languages - GSoC 2010
Previous Message Dhiraj Lohiya 2010-04-07 20:24:53 Enhancing phonetic search support for more languages - GSoC 2010