Commit4983222

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 parent5835998 commit4983222Copy full SHA for 4983222

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -5945,7 +5945,7 @@ SELECT regexp_matches('abc01234xyz', '(?:(.?)(\d+)(.)){1,1}');`
`5945`	`5945`	`<para>`
`5946`	`5946`	`Here is a more`
`5947`	`5947`	`complex example:`
`5948`		`- <literal>to_timestamp('15:12:02.020.001230', 'HH:MI:SS.MS.US')</literal>`
	`5948`	`+ <literal>to_timestamp('15:12:02.020.001230', 'HH24:MI:SS.MS.US')</literal>`
`5949`	`5949`	`is 15 hours, 12 minutes, and 2 seconds + 20 milliseconds +`
`5950`	`5950`	`1230 microseconds = 2.021230 seconds.`
`5951`	`5951`	`</para>`

Comments

(0)