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 /src/test/regress/sql | |
| parent | 03caf7649b968d63ec598205965fda68f073b47b (diff) | |
| download | postgresql-1c757c49fa95c8db90fae69787ac27d5ebabad4b.tar.gz | |
> > 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 'src/test/regress/sql')
| -rw-r--r-- | src/test/regress/sql/timestamptz.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/src/test/regress/sql/timestamptz.sql b/src/test/regress/sql/timestamptz.sql index 71414f198e..2a789b87bd 100644 --- a/src/test/regress/sql/timestamptz.sql +++ b/src/test/regress/sql/timestamptz.sql @@ -189,6 +189,9 @@ SELECT '' AS to_char_8, to_char(d1, 'YYYYTH YYYYth Jth') SELECT '' AS to_char_9, to_char(d1, 'YYYY A.D. YYYY a.d. YYYY bc HH:MI:SS P.M. HH:MI:SS p.m. HH:MI:SS pm') FROM TIMESTAMPTZ_TBL; +SELECT '' AS to_char_10, to_char(d1, 'YYYY WW IYYY IYY IY I IW') + FROM TIMESTAMPTZ_TBL; + -- TO_TIMESTAMP() SELECT '' AS to_timestamp_1, to_timestamp('0097/Feb/16 --> 08:14:30', 'YYYY/Mon/DD --> HH:MI:SS'); @@ -220,4 +223,9 @@ SELECT '' AS to_timestamp_13, to_timestamp('95-1116', 'YY-MMDD'); SELECT '' AS to_timestamp_14, to_timestamp('995-1116', 'YYY-MMDD'); +SELECT '' AS to_timestamp_15, to_timestamp('200401', 'IYYYIW'); + +SELECT '' AS to_timestamp_16, to_timestamp('200401', 'YYYYWW'); + + SET DateStyle TO DEFAULT; |