to_char(): Do not count negative sign as a digit for time values
authorBruce Momjian <bruce@momjian.us>
Tue, 6 Oct 2015 00:51:46 +0000 (20:51 -0400)
committerBruce Momjian <bruce@momjian.us>
Tue, 6 Oct 2015 00:51:46 +0000 (20:51 -0400)
commit2d87eedc1d4468d331035bbe55f140f180d20144
tree18e4a1784b539cfe3ca02d6da4f742cc5d7a68b4
parent6d8b2aa83af70e20323caf23961667dc4c149276
to_char(): Do not count negative sign as a digit for time values

For time masks, like HH24, MI, SS, CC, MM, do not count the negative
sign as part of the zero-padding length specified by the mask, e.g. have
to_char('-4 years'::interval, 'YY') return '-04', not '-4'.

Report by Craig Ringer
src/backend/utils/adt/formatting.c
src/test/regress/expected/timestamp.out
src/test/regress/expected/timestamptz.out