Commitf7e7d6f

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 commitd3cd36a, but I didn't thinkof backpatching it.Report:https://postgr.es/m/20161229170043.10139.21416@wrigleys.postgresql.org

1 parent21e24eb commitf7e7d6fCopy full SHA for f7e7d6f

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -6230,7 +6230,7 @@ SELECT regexp_matches('abc01234xyz', '(?:(.?)(\d+)(.)){1,1}');`
`6230`	`6230`	`<para>`
`6231`	`6231`	`Here is a more`
`6232`	`6232`	`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>`
`6234`	`6234`	`is 15 hours, 12 minutes, and 2 seconds + 20 milliseconds +`
`6235`	`6235`	`1230 microseconds = 2.021230 seconds.`
`6236`	`6236`	`</para>`

Comments

(0)