diff options
| author | Bruce Momjian | 2010-02-16 21:18:02 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2010-02-16 21:18:02 +0000 |
| commit | 70d8a2c29e809c90f7caaded2b4f47b1cf18d01d (patch) | |
| tree | ad6915246553b0ff65b2855719abf417666c1c2b /src/test | |
| parent | 55ea144a14c5c1831a3eca5d261860b840742814 (diff) | |
Honor to_char() "FM" specification in YYY, YY, and Y; it was already
honored by YYYY. Also document Oracle "toggle" FM behavior.
Per report from Guy Rouillier
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/timestamp.out | 8 | ||||
| -rw-r--r-- | src/test/regress/expected/timestamptz.out | 8 |
2 files changed, 8 insertions, 8 deletions
diff --git a/src/test/regress/expected/timestamp.out b/src/test/regress/expected/timestamp.out index d99c1107240..0062f8f3807 100644 --- a/src/test/regress/expected/timestamp.out +++ b/src/test/regress/expected/timestamp.out @@ -1063,8 +1063,8 @@ SELECT '' AS to_char_4, to_char(d1, 'FMY,YYY FMYYYY FMYYY FMYY FMY FMCC FMQ FMMM | 1,997 1997 997 97 7 20 1 2 7 45 14 6 2450494 | 1,997 1997 997 97 7 20 1 2 7 46 15 7 2450495 | 1,997 1997 997 97 7 20 1 2 7 47 16 1 2450496 - | 0,097 97 097 97 7 1 1 2 7 47 16 3 1686042 - | 0,097 97 097 97 7 1 1 2 7 47 16 7 1756536 + | 0,097 97 97 97 7 1 1 2 7 47 16 3 1686042 + | 0,097 97 97 97 7 1 1 2 7 47 16 7 1756536 | 0,597 597 597 97 7 6 1 2 7 47 16 5 1939157 | 1,097 1097 097 97 7 11 1 2 7 47 16 3 2121778 | 1,697 1697 697 97 7 17 1 2 7 47 16 7 2340924 @@ -1561,8 +1561,8 @@ SELECT '' AS to_char_11, to_char(d1, 'FMIYYY FMIYY FMIY FMI FMIW FMIDDD FMID') | 1997 997 97 7 7 47 5 | 1997 997 97 7 7 48 6 | 1997 997 97 7 7 49 7 - | 97 097 97 7 7 44 2 - | 97 097 97 7 7 48 6 + | 97 97 97 7 7 44 2 + | 97 97 97 7 7 48 6 | 597 597 97 7 7 46 4 | 1097 097 97 7 7 44 2 | 1697 697 97 7 7 48 6 diff --git a/src/test/regress/expected/timestamptz.out b/src/test/regress/expected/timestamptz.out index f35bb14d352..1096f28e6bb 100644 --- a/src/test/regress/expected/timestamptz.out +++ b/src/test/regress/expected/timestamptz.out @@ -1148,8 +1148,8 @@ SELECT '' AS to_char_4, to_char(d1, 'FMY,YYY FMYYYY FMYYY FMYY FMY FMCC FMQ FMMM | 1,997 1997 997 97 7 20 1 2 7 45 14 6 2450494 | 1,997 1997 997 97 7 20 1 2 7 46 15 7 2450495 | 1,997 1997 997 97 7 20 1 2 7 47 16 1 2450496 - | 0,097 97 097 97 7 1 1 2 7 47 16 3 1686042 - | 0,097 97 097 97 7 1 1 2 7 47 16 7 1756536 + | 0,097 97 97 97 7 1 1 2 7 47 16 3 1686042 + | 0,097 97 97 97 7 1 1 2 7 47 16 7 1756536 | 0,597 597 597 97 7 6 1 2 7 47 16 5 1939157 | 1,097 1097 097 97 7 11 1 2 7 47 16 3 2121778 | 1,697 1697 697 97 7 17 1 2 7 47 16 7 2340924 @@ -1655,8 +1655,8 @@ SELECT '' AS to_char_11, to_char(d1, 'FMIYYY FMIYY FMIY FMI FMIW FMIDDD FMID') | 1997 997 97 7 7 47 5 | 1997 997 97 7 7 48 6 | 1997 997 97 7 7 49 7 - | 97 097 97 7 7 44 2 - | 97 097 97 7 7 48 6 + | 97 97 97 7 7 44 2 + | 97 97 97 7 7 48 6 | 597 597 97 7 7 46 4 | 1097 097 97 7 7 44 2 | 1697 697 97 7 7 48 6 |