Commit7924036

committed

Doc: fix bogus to_date() examples.

November doesn't have 31 days. Remarkably, this thinkohas escaped detection since commit3f19987.Noted by Y. Saburov.Discussion:https://postgr.es/m/171276122213.681.531905738590773705@wrigleys.postgresql.org

1 parent0341d4b commit7924036Copy full SHA for 7924036

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -6713,11 +6713,11 @@ SELECT regexp_match('abc01234xyz', '(?:(.?)(\d+)(.)){1,1}');`
`6713`	`6713`	`use some non-digit character or template after <literal>YYYY</literal>,`
`6714`	`6714`	`otherwise the year is always interpreted as 4 digits. For example`
`6715`	`6715`	`(with the year 20000):`
`6716`		`- <literal>to_date('200001131', 'YYYYMMDD')</literal> will be`
	`6716`	`+ <literal>to_date('200001130', 'YYYYMMDD')</literal> will be`
`6717`	`6717`	`interpreted as a 4-digit year; instead use a non-digit`
`6718`	`6718`	`separator after the year, like`
`6719`		`- <literal>to_date('20000-1131', 'YYYY-MMDD')</literal> or`
`6720`		`- <literal>to_date('20000Nov31', 'YYYYMonDD')</literal>.`
	`6719`	`+ <literal>to_date('20000-1130', 'YYYY-MMDD')</literal> or`
	`6720`	`+ <literal>to_date('20000Nov30', 'YYYYMonDD')</literal>.`
`6721`	`6721`	`</para>`
`6722`	`6722`	`</listitem>`
`6723`	`6723`

Comments

(0)