diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2024-04-11 11:09:00 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2024-04-11 11:09:00 -0400 |
| commit | 6d4f062714953ed0ec865ff96d5af122b8c3e77f (patch) | |
| tree | 8aff1d9a2401d094e8e201e35be32b1220a6d632 /doc/src | |
| parent | 772faafca1b288c4dd66b7150a7831c27b768003 (diff) | |
| download | postgresql-6d4f062714953ed0ec865ff96d5af122b8c3e77f.tar.gz postgresql-6d4f062714953ed0ec865ff96d5af122b8c3e77f.zip | |
Doc: fix bogus to_date() examples.
November doesn't have 31 days. Remarkably, this thinko
has escaped detection since commit 3f1998727.
Noted by Y. Saburov.
Discussion: https://postgr.es/m/171276122213.681.531905738590773705@wrigleys.postgresql.org
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index b432914dc88..8dfb42ad4db 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -8401,11 +8401,11 @@ SELECT regexp_match('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}'); use some non-digit character or template after <literal>YYYY</literal>, otherwise the year is always interpreted as 4 digits. For example (with the year 20000): - <literal>to_date('200001131', 'YYYYMMDD')</literal> will be + <literal>to_date('200001130', 'YYYYMMDD')</literal> will be interpreted as a 4-digit year; instead use a non-digit separator after the year, like - <literal>to_date('20000-1131', 'YYYY-MMDD')</literal> or - <literal>to_date('20000Nov31', 'YYYYMonDD')</literal>. + <literal>to_date('20000-1130', 'YYYY-MMDD')</literal> or + <literal>to_date('20000Nov30', 'YYYYMonDD')</literal>. </para> </listitem> |