diff options
| author | Bruce Momjian <bruce@momjian.us> | 2010-02-23 16:14:26 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2010-02-23 16:14:26 +0000 |
| commit | a54803149a7beeea6dc8e624c3da561b7f6f5fc9 (patch) | |
| tree | 8e211f3d81e42277beca211fb88a57894c004d84 /doc/src | |
| parent | 4f56dc3fb4266565650542f2a8cb6babe4b46d11 (diff) | |
| download | postgresql-a54803149a7beeea6dc8e624c3da561b7f6f5fc9.tar.gz postgresql-a54803149a7beeea6dc8e624c3da561b7f6f5fc9.zip | |
Revert recent change of to_char('HH12') handling for intervals; instead
improve documentation, and add C comment.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 52049e7a738..689cd34e93b 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.505 2010/02/19 00:15:25 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.506 2010/02/23 16:14:25 momjian Exp $ --> <chapter id="functions"> <title>Functions and Operators</title> @@ -5317,8 +5317,9 @@ SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1,3})'); <listitem> <para> <function>to_char(interval)</function> formats <literal>HH</> and - <literal>HH12</> as hours in a single day, while <literal>HH24</> - can output hours exceeding a single day, e.g., >24. + <literal>HH12</> as shown on a 12-hour clock, i.e. zero hours + and 36 hours output as <literal>12</>, while <literal>HH24</> + outputs the full hour value, which can exceed 23 for intervals. </para> </listitem> |