diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-12-25 03:36:24 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-12-25 03:36:24 +0000 |
| commit | 1c757c49fa95c8db90fae69787ac27d5ebabad4b (patch) | |
| tree | 5fb7afa9e592e218d33d8f6fe9fb8b90eff79ca3 /doc/src | |
| parent | 03caf7649b968d63ec598205965fda68f073b47b (diff) | |
| download | postgresql-1c757c49fa95c8db90fae69787ac27d5ebabad4b.tar.gz postgresql-1c757c49fa95c8db90fae69787ac27d5ebabad4b.zip | |
> > I have no idea if this in Oracle or not. But it's something I
> > needed, and other people in the past asked about it too.
>
> It is in Oracle, but you aren't exactly on the spot. It should be
>
> IYYY - 4 digits ('2003')
> IYY - 3 digits ('003')
> IY - 2 digits ('03')
> I - 1 digit ('3')
Here is an updated patch that does that.
Kurt Roeckx
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 18 |
1 files changed, 17 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 16ed17b118a..c7c0f23c8fa 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.183 2003/12/18 03:59:07 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.184 2003/12/25 03:36:23 momjian Exp $ PostgreSQL documentation --> @@ -3984,6 +3984,22 @@ substring('foobar' from 'o(.)b') <lineannotation>o</lineannotation> <entry>last digit of year</entry> </row> <row> + <entry><literal>IYYY</literal></entry> + <entry>ISO year (4 and more digits)</entry> + </row> + <row> + <entry><literal>IYY</literal></entry> + <entry>last 3 digits of ISO year</entry> + </row> + <row> + <entry><literal>IY</literal></entry> + <entry>last 2 digits of ISO year</entry> + </row> + <row> + <entry><literal>I</literal></entry> + <entry>last digits of ISO year</entry> + </row> + <row> <entry><literal>BC</literal> or <literal>B.C.</literal> or <literal>AD</literal> or <literal>A.D.</literal></entry> <entry>era indicator (upper case)</entry> |