diff options
Diffstat (limited to 'src/test/regress/expected/timestamp.out')
| -rw-r--r-- | src/test/regress/expected/timestamp.out | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/src/test/regress/expected/timestamp.out b/src/test/regress/expected/timestamp.out index 7557bf2900..d6f14ff6ef 100644 --- a/src/test/regress/expected/timestamp.out +++ b/src/test/regress/expected/timestamp.out @@ -1327,15 +1327,15 @@ SELECT '' AS to_char_9, to_char(d1, 'YYYY A.D. YYYY a.d. YYYY bc HH:MI:SS P.M. H -- TO_TIMESTAMP() SELECT '' AS to_timestamp_1, to_timestamp('0097/Feb/16 --> 08:14:30', 'YYYY/Mon/DD --> HH:MI:SS'); - to_timestamp_1 | to_timestamp -----------------+-------------------------- - | Sat Feb 16 08:14:30 0097 + to_timestamp_1 | to_timestamp +----------------+------------------------------ + | Sat Feb 16 08:14:30 0097 PST (1 row) SELECT '' AS to_timestamp_2, to_timestamp('97/2/16 8:14:30', 'FMYYYY/FMMM/FMDD FMHH:FMMI:FMSS'); - to_timestamp_2 | to_timestamp -----------------+-------------------------- - | Sat Feb 16 08:14:30 0097 + to_timestamp_2 | to_timestamp +----------------+------------------------------ + | Sat Feb 16 08:14:30 0097 PST (1 row) SELECT '' AS to_timestamp_3, to_timestamp('1985 January 12', 'YYYY FMMonth DD'); @@ -1352,9 +1352,9 @@ SELECT '' AS to_timestamp_4, to_timestamp('My birthday-> Year: 1976, Month: May, (1 row) SELECT '' AS to_timestamp_5, to_timestamp('1,582nd VIII 21', 'Y,YYYth FMRM DD'); - to_timestamp_5 | to_timestamp -----------------+-------------------------- - | Sat Aug 21 00:00:00 1582 + to_timestamp_5 | to_timestamp +----------------+------------------------------ + | Sat Aug 21 00:00:00 1582 PST (1 row) SELECT '' AS to_timestamp_6, to_timestamp('15 "text between quote marks" 98 54 45', @@ -1386,9 +1386,9 @@ SELECT '' AS to_timestamp_10, to_timestamp('19971116', 'YYYYMMDD'); (1 row) SELECT '' AS to_timestamp_11, to_timestamp('20000-1116', 'YYYY-MMDD'); - to_timestamp_11 | to_timestamp ------------------+--------------------------- - | Thu Nov 16 00:00:00 20000 + to_timestamp_11 | to_timestamp +-----------------+------------------------------- + | Thu Nov 16 00:00:00 20000 PST (1 row) SELECT '' AS to_timestamp_12, to_timestamp('9-1116', 'Y-MMDD'); |