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:06
Message-ID: 20051203164506.C3A8C9DCBA6@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.

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)

pgsql-committers by date

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

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