@@ -715,7 +715,7 @@ SELECT '' AS four, f1 AS abstime,
715715SELECT '' AS "15", f1 AS timestamp, date( f1) AS date
716716 FROM TEMP_TIMESTAMP
717717 WHERE f1 <> timestamp 'current'
718- ORDER BY date;
718+ ORDER BY date, timestamp ;
719719 15 | timestamp | date
720720----+------------------------------+------------
721721 | epoch | 01-01-1970
@@ -726,11 +726,11 @@ SELECT '' AS "15", f1 AS timestamp, date( f1) AS date
726726 | Tue Dec 31 17:32:01 1996 PST | 12-31-1996
727727 | Fri Dec 31 17:32:01 1999 PST | 12-31-1999
728728 | Sat Jan 01 17:32:01 2000 PST | 01-01-2000
729- | Wed Mar 15 08:14:01 2000 PST | 03-15-2000
730- | Wed Mar 15 04:14:02 2000 PST | 03-15-2000
729+ | Wed Mar 15 01:14:05 2000 PST | 03-15-2000
731730 | Wed Mar 15 02:14:03 2000 PST | 03-15-2000
732731 | Wed Mar 15 03:14:04 2000 PST | 03-15-2000
733- | Wed Mar 15 01:14:05 2000 PST | 03-15-2000
732+ | Wed Mar 15 04:14:02 2000 PST | 03-15-2000
733+ | Wed Mar 15 08:14:01 2000 PST | 03-15-2000
734734 | Sun Dec 31 17:32:01 2000 PST | 12-31-2000
735735 | Mon Jan 01 17:32:01 2001 PST | 01-01-2001
736736(15 rows)
@@ -760,7 +760,7 @@ SELECT '' AS "15", f1 AS timestamp, abstime( f1) AS abstime
760760SELECT '' AS four, f1 AS abstime, date( f1) AS date
761761 FROM ABSTIME_TBL
762762 WHERE isfinite(f1) AND f1 <> abstime 'current'
763- ORDER BY date;
763+ ORDER BY date, abstime ;
764764 four | abstime | date
765765------+------------------------------+------------
766766 | Sat May 10 23:59:12 1947 PST | 05-10-1947
