Skip site navigation (1) Skip section navigation (2)

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:23
Message-ID: 20051203164523.2DA249DCBBD@postgresql.org (view raw or flat)
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.

Tags:
----
REL8_1_STABLE

Modified Files:
--------------
    pgsql/doc/src/sgml:
        func.sgml (r1.291.2.2 -> r1.291.2.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.291.2.2&r2=1.291.2.3)
    pgsql/src/backend/utils/adt:
        formatting.c (r1.101.2.1 -> r1.101.2.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/formatting.c.diff?r1=1.101.2.1&r2=1.101.2.2)

pgsql-committers by date

Next:From: James William PyeDate: 2005-12-03 19:44:33
Subject: python - be: Fix Portal parameters.
Previous:From: Bruce MomjianDate: 2005-12-03 16:45:06
Subject: pgsql: Allow to_char(interval) and to_char(time) to use AM/PM

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group