]> granicus.if.org Git - postgresql/commit
Allow to_char(interval) and to_char(time) to use AM/PM specifications.
authorBruce Momjian <bruce@momjian.us>
Sat, 3 Dec 2005 16:45:06 +0000 (16:45 +0000)
committerBruce Momjian <bruce@momjian.us>
Sat, 3 Dec 2005 16:45:06 +0000 (16:45 +0000)
commitd20901a39bc6b968853546f4e76ba4337aa5eaa0
tree55d3097621c5447b02fb37314d369c7bcb1aae39
parenteb339c7840522a229967d8155a6920282cfb07c1
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.
doc/src/sgml/func.sgml
src/backend/utils/adt/formatting.c