pgsql: to_char(): Do not count negative sign as a digit for time values

Started by Bruce Momjianalmost 11 years ago1 messagescomitters

bruce@momjian.us

almost 11 years ago

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

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/2d87eedc1d4468d331035bbe55f140f180d20144

Modified Files
--------------
src/backend/utils/adt/formatting.c | 28 ++++++++++++++++++----------
src/test/regress/expected/timestamp.out | 6 +++---
src/test/regress/expected/timestamptz.out | 6 +++---
3 files changed, 24 insertions(+), 16 deletions(-)

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