Commit6d4f062

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 parent772faaf commit6d4f062Copy full SHA for 6d4f062

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -8401,11 +8401,11 @@ SELECT regexp_match('abc01234xyz', '(?:(.?)(\d+)(.)){1,1}');`
`8401`	`8401`	`use some non-digit character or template after <literal>YYYY</literal>,`
`8402`	`8402`	`otherwise the year is always interpreted as 4 digits. For example`
`8403`	`8403`	`(with the year 20000):`
`8404`		`- <literal>to_date('200001131', 'YYYYMMDD')</literal> will be`
	`8404`	`+ <literal>to_date('200001130', 'YYYYMMDD')</literal> will be`
`8405`	`8405`	`interpreted as a 4-digit year; instead use a non-digit`
`8406`	`8406`	`separator after the year, like`
`8407`		`- <literal>to_date('20000-1131', 'YYYY-MMDD')</literal> or`
`8408`		`- <literal>to_date('20000Nov31', 'YYYYMonDD')</literal>.`
	`8407`	`+ <literal>to_date('20000-1130', 'YYYY-MMDD')</literal> or`
	`8408`	`+ <literal>to_date('20000Nov30', 'YYYYMonDD')</literal>.`
`8409`	`8409`	`</para>`
`8410`	`8410`	`</listitem>`
`8411`	`8411`

Comments

(0)