diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 655c63a7931..27a6bbc7c5a 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -962,6 +962,20 @@ keyword (example: <literal>'"Hello Year: "YYYY'</literal>). </para> </listitem> + + <listitem> + <para> + <literal>YYYY</literal> conversion from string to timestamp or + date is limited if you use year great than 4-digits. You must + use after <literal>YYYY</literal> some non-digit char or template + else year is always interpreted as 4-digits. For example (with year + 20000): + <literal> to_date('200001131', 'YYYYMMDD') <literal> will bad + interpreded as 4-digits year, right is use after year non-digit + separator <literal> to_date('20000-1131', 'YYYY-MMDD')<literal> or + <literal> to_date('20000Nov31', 'YYYYMonDD')<literal>. + </para> + </listitem> </itemizedlist> </para> |