pgsql: Allow to_char(interval) and to_char(time) to use AM/PM

From: momjian(at)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow to_char(interval) and to_char(time) to use AM/PM
Date: 2005-12-03 16:45:06
Message-ID: 20051203164506.C3A8C9DCBA6@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Allow to_char(interval) and to_char(time) to use AM/PM specifications.
Map them to a single day, so '30 hours' is 'AM'.

Have to_char(interval) and to_char(time) use "HH", "HH12" as 12-hour
intervals, rather than bypass and print the full interval hours. This
is neeeded because to_char(time) is mapped to interval in this function.
Intervals should use "HH24", and document suggestion.

Allow "D" format specifiers for interval/time.

Modified Files:
--------------
pgsql/doc/src/sgml:
func.sgml (r1.296 -> r1.297)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.296&r2=1.297)
pgsql/src/backend/utils/adt:
formatting.c (r1.102 -> r1.103)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/formatting.c.diff?r1=1.102&r2=1.103)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2005-12-03 16:45:23 pgsql: Allow to_char(interval) and to_char(time) to use AM/PM
Previous Message Bruce Momjian 2005-12-03 13:03:41 pgsql: Item removed: < * Add function to return the thread safety