postgres.git / summary / log / commit / refs

commit    ea853db4a58fe8c0fcfe7f945f5ca5c800264e5a
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Thu Dec 29 23:05:34 2016 +0000
First released in: 9.2.20, 9.3.16, 9.4.11, 9.5.6, 9.6.2

    Fix incorrect example of to_timestamp() usage.
    
    Must use HH24 not HH to read a hour value exceeding 12.
    
    This was already fixed in HEAD in commit d3cd36a13, but I didn't think
    of backpatching it.
    
    Report: https://postgr.es/m/20161229170043.10139.21416@wrigleys.postgresql.org


 doc/src/sgml/func.sgml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 5a3e9977e1a..b4cc240c2cf 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -5980,7 +5980,7 @@ SELECT regexp_matches('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}');
       <para>
        Here is a more
        complex example:
-       <literal>to_timestamp('15:12:02.020.001230', 'HH:MI:SS.MS.US')</literal>
+       <literal>to_timestamp('15:12:02.020.001230', 'HH24:MI:SS.MS.US')</literal>
        is 15 hours, 12 minutes, and 2 seconds + 20 milliseconds +
        1230 microseconds = 2.021230 seconds.
       </para>


[parent: 0b947b692c5e]