diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2016-12-29 18:05:34 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2016-12-29 18:05:54 -0500 |
| commit | ea853db4a58fe8c0fcfe7f945f5ca5c800264e5a (patch) | |
| tree | 9685f24da6e368f1f16d567ca9876cf41259e5b2 | |
| parent | 0b947b692c5e6ef3c20a6b24cad5a3b29f3210f1 (diff) | |
| download | postgresql-ea853db4a58fe8c0fcfe7f945f5ca5c800264e5a.tar.gz postgresql-ea853db4a58fe8c0fcfe7f945f5ca5c800264e5a.zip | |
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
| -rw-r--r-- | doc/src/sgml/func.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
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> |