diff options
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/src/sgml/func.sgml | 21 |
1 files changed, 16 insertions, 5 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 0023a28b0aa..597be311047 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -785,11 +785,11 @@ </row> <row> <entry>W</entry> - <entry>week of month</entry> + <entry>week of month (1-5) where first week start on the first day of the month</entry> </row> <row> <entry>WW</entry> - <entry>week number of year</entry> + <entry>week number of year (1-53) where first week start on the first day of the year</entry> </row> <row> <entry>CC</entry> @@ -811,6 +811,14 @@ <entry>rm</entry> <entry>month in Roman Numerals (I-XII; I=JAN) - lower case</entry> </row> + <row> + <entry>TZ</entry> + <entry>timezone string - upper case (not supported in the to_timestamp())</entry> + </row> + <row> + <entry>tz</entry> + <entry>timezone string - lower case (not supported in the to_timestamp())</entry> + </row> </tbody> </tgroup> </table> @@ -871,9 +879,12 @@ <listitem> <para> <function>to_timestamp</function> and <function>to_date</function> - skip blank space if the <literal>FX</literal> option is - not used. <literal>FX</literal> must be specified as the first item - in the template. + skip multiple blank space in converted string if the <literal>FX</literal> option + is not used. <literal>FX</literal> must be specified as the first item + in the template; for example + <literal>to_timestamp('2000 JUN','YYYY MON')</literal> is right, but + <literal>to_timestamp('2000 JUN','FXYYYY MON')</literal> returns error, + because to_timestamp() expects one blank space only. </para> </listitem> |