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)
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 |