pgsql-server/ oc/src/sgml/func.sgml rc/backend ...

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: momjian@svr1.postgresql.org 03/12/24 23:36:24

Modified files:
doc/src/sgml : func.sgml
src/backend/utils/adt: formatting.c timestamp.c
src/include/utils: timestamp.h
src/test/regress/expected: timestamptz.out
src/test/regress/sql: timestamptz.sql

Log message:

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