diff options
| author | Bruce Momjian <bruce@momjian.us> | 2000-11-25 05:00:33 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2000-11-25 05:00:33 +0000 |
| commit | 3f1998727d4e7b9ef285ae8ea90acc9811164931 (patch) | |
| tree | afb5af8127873e47a4bcb102b34e0d4f07e2bcbe /doc/src | |
| parent | 91ba4cc76182ed0a501fd53a775eb87341c60141 (diff) | |
here is a patch for formatting.c (to_char/timestampt()), for 7.1
it fixing Y,YY,YYY,YYYY conversion, the docs and regress tests update
are included too.
During the patch testing I found small bug in miscadmin.h in
convertstr() declaration. Here it's fixed too.
Thanks
Karel
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> |