> > I have no idea if this in Oracle or not. But it's something I
authorBruce Momjian <bruce@momjian.us>
Thu, 25 Dec 2003 03:36:24 +0000 (03:36 +0000)
committerBruce Momjian <bruce@momjian.us>
Thu, 25 Dec 2003 03:36:24 +0000 (03:36 +0000)
commit1c757c49fa95c8db90fae69787ac27d5ebabad4b
tree5fb7afa9e592e218d33d8f6fe9fb8b90eff79ca3
parent03caf7649b968d63ec598205965fda68f073b47b
> > 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
doc/src/sgml/func.sgml
src/backend/utils/adt/formatting.c
src/backend/utils/adt/timestamp.c
src/include/utils/timestamp.h
src/test/regress/expected/timestamptz.out
src/test/regress/sql/timestamptz.sql