|
785 | 785 | </row>
|
786 | 786 | <row>
|
787 | 787 | <entry>W</entry>
|
788 |
| -<entry>week of month</entry> |
| 788 | +<entry>week of month (1-5) where first week start on the first day of the month</entry> |
789 | 789 | </row>
|
790 | 790 | <row>
|
791 | 791 | <entry>WW</entry>
|
792 |
| -<entry>week number of year</entry> |
| 792 | +<entry>week number of year (1-53) where first week start on the first day of the year</entry> |
793 | 793 | </row>
|
794 | 794 | <row>
|
795 | 795 | <entry>CC</entry>
|
|
811 | 811 | <entry>rm</entry>
|
812 | 812 | <entry>month in Roman Numerals (I-XII; I=JAN) - lower case</entry>
|
813 | 813 | </row>
|
| 814 | + <row> |
| 815 | +<entry>TZ</entry> |
| 816 | +<entry>timezone string - upper case (not supported in the to_timestamp())</entry> |
| 817 | + </row> |
| 818 | + <row> |
| 819 | +<entry>tz</entry> |
| 820 | +<entry>timezone string - lower case (not supported in the to_timestamp())</entry> |
| 821 | + </row> |
814 | 822 | </tbody>
|
815 | 823 | </tgroup>
|
816 | 824 | </table>
|
|
871 | 879 | <listitem>
|
872 | 880 | <para>
|
873 | 881 | <function>to_timestamp</function> and <function>to_date</function>
|
874 |
| - skip blank space if the <literal>FX</literal> option is |
875 |
| - not used. <literal>FX</literal> must be specified as the first item |
876 |
| - in the template. |
| 882 | + skip multiple blank space in converted string if the <literal>FX</literal> option |
| 883 | + is not used. <literal>FX</literal> must be specified as the first item |
| 884 | + in the template; for example |
| 885 | + <literal>to_timestamp('2000 JUN','YYYY MON')</literal> is right, but |
| 886 | + <literal>to_timestamp('2000 JUN','FXYYYY MON')</literal> returns error, |
| 887 | + because to_timestamp() expects one blank space only. |
877 | 888 | </para>
|
878 | 889 | </listitem>
|
879 | 890 |
|
|