File tree Expand file tree Collapse file tree 2 files changed +10
-10
lines changed Expand file tree Collapse file tree 2 files changed +10
-10
lines changed Original file line number Diff line number Diff line change 966
966
<listitem>
967
967
<para>
968
968
<literal>YYYY</literal> conversion from string to timestamp or
969
- date is limited if you use year great than 4-digits. You must
970
- use after <literal>YYYY</literal> some non-digit char or template
971
- else year is always interpreted as 4-digits. For example (with year
972
- 20000):
973
- <literal> to_date('200001131', 'YYYYMMDD') <literal> will bad
974
- interpreded as 4-digits year, right is use after year non-digit
975
- separator <literal> to_date('20000-1131', 'YYYY-MMDD')<literal> or
976
- <literal> to_date('20000Nov31', 'YYYYMonDD')<literal>.
969
+ date is limited if you use a year longer than 4-digits. You must
970
+ use some non-digit character or template after <literal>YYYY</literal>,
971
+ otherwise the year is always interpreted as 4-digits. For example
972
+ (with year 20000):
973
+ <literal>to_date('200001131', 'YYYYMMDD')</literal> will be
974
+ interpreted as a 4-digit year, better is to use a non-digit
975
+ separator after the year, like
976
+ <literal>to_date('20000-1131', 'YYYY-MMDD')</literal> or
977
+ <literal>to_date('20000Nov31', 'YYYYMonDD')</literal>.
977
978
</para>
978
979
</listitem>
979
980
</itemizedlist>
Original file line number Diff line number Diff line change 1
1
<!-- reference.sgml
2
- $Header: /cvsroot/pgsql/doc/src/sgml/reference.sgml,v 1.9 2000/11/24 17:44:22 petere Exp $
2
+ $Header: /cvsroot/pgsql/doc/src/sgml/reference.sgml,v 1.10 2000/11/25 13:20:05 petere Exp $
3
3
4
4
PostgreSQL Reference Manual
5
5
-->
@@ -88,7 +88,6 @@ PostgreSQL Reference Manual
88
88
&selectInto;
89
89
&set;
90
90
&setConstraints;
91
- &setSession;
92
91
&setTransaction;
93
92
&show;
94
93
&truncate;
You can’t perform that action at this time.
0 commit comments