Content-Length: 258165 | pFad | http://github.com/postgrespro/postgres_cluster/commit/f7e7d6fcefc4083d929075be5e121114086a6f98

FB Fix incorrect example of to_timestamp() usage. · postgrespro/postgres_cluster@f7e7d6f · GitHub
Skip to content

Commit f7e7d6f

Browse files
committed
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 d3cd36a, but I didn't think of backpatching it. Report: https://postgr.es/m/20161229170043.10139.21416@wrigleys.postgresql.org
1 parent 21e24eb commit f7e7d6f

File tree

1 file changed

+1
-1
lines changed

1 file changed

+1
-1
lines changed

doc/src/sgml/func.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -6230,7 +6230,7 @@ SELECT regexp_matches('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}');
62306230
<para>
62316231
Here is a more
62326232
complex example:
6233-
<literal>to_timestamp('15:12:02.020.001230', 'HH:MI:SS.MS.US')</literal>
6233+
<literal>to_timestamp('15:12:02.020.001230', 'HH24:MI:SS.MS.US')</literal>
62346234
is 15 hours, 12 minutes, and 2 seconds + 20 milliseconds +
62356235
1230 microseconds = 2.021230 seconds.
62366236
</para>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres_cluster/commit/f7e7d6fcefc4083d929075be5e121114086a6f98

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy