> > I have no idea if this in Oracle or not. But it's something I
Bruce Momjian <bruce@momjian.us>
> > 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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +17 −1 |
| src/backend/utils/adt/formatting.c | modified | +51 −6 |
| src/backend/utils/adt/timestamp.c | modified | +60 −2 |
| src/include/utils/timestamp.h | modified | +2 −1 |
| src/test/regress/expected/timestamptz.out | modified | +82 −0 |
| src/test/regress/sql/timestamptz.sql | modified | +8 −0 |