summaryrefslogtreecommitdiff
path: root/src/test/regress/expected/timestamp.out
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/expected/timestamp.out')
-rw-r--r--src/test/regress/expected/timestamp.out137
1 files changed, 69 insertions, 68 deletions
diff --git a/src/test/regress/expected/timestamp.out b/src/test/regress/expected/timestamp.out
index 89a856bac98..233ac50d7e6 100644
--- a/src/test/regress/expected/timestamp.out
+++ b/src/test/regress/expected/timestamp.out
@@ -931,75 +931,76 @@ SELECT d1 as "timestamp",
date_part( 'decade', d1) AS decade,
date_part( 'century', d1) AS century,
date_part( 'millennium', d1) AS millennium,
- round(date_part( 'julian', d1)) AS julian
+ round(date_part( 'julian', d1)) AS julian,
+ date_part( 'epoch', d1) AS epoch
FROM TIMESTAMP_TBL;
- timestamp | decade | century | millennium | julian
------------------------------+-----------+-----------+------------+-----------
- -infinity | -Infinity | -Infinity | -Infinity | -Infinity
- infinity | Infinity | Infinity | Infinity | Infinity
- Thu Jan 01 00:00:00 1970 | 197 | 20 | 2 | 2440588
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:02 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01.4 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01.5 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01.6 1997 | 199 | 20 | 2 | 2450491
- Thu Jan 02 00:00:00 1997 | 199 | 20 | 2 | 2450451
- Thu Jan 02 03:04:05 1997 | 199 | 20 | 2 | 2450451
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Tue Jun 10 17:32:01 1997 | 199 | 20 | 2 | 2450611
- Sat Sep 22 18:19:20 2001 | 200 | 21 | 3 | 2452176
- Wed Mar 15 08:14:01 2000 | 200 | 20 | 2 | 2451619
- Wed Mar 15 13:14:02 2000 | 200 | 20 | 2 | 2451620
- Wed Mar 15 12:14:03 2000 | 200 | 20 | 2 | 2451620
- Wed Mar 15 03:14:04 2000 | 200 | 20 | 2 | 2451619
- Wed Mar 15 02:14:05 2000 | 200 | 20 | 2 | 2451619
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:00 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Tue Jun 10 18:32:01 1997 | 199 | 20 | 2 | 2450611
- Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
- Tue Feb 11 17:32:01 1997 | 199 | 20 | 2 | 2450492
- Wed Feb 12 17:32:01 1997 | 199 | 20 | 2 | 2450493
- Thu Feb 13 17:32:01 1997 | 199 | 20 | 2 | 2450494
- Fri Feb 14 17:32:01 1997 | 199 | 20 | 2 | 2450495
- Sat Feb 15 17:32:01 1997 | 199 | 20 | 2 | 2450496
- Sun Feb 16 17:32:01 1997 | 199 | 20 | 2 | 2450497
- Tue Feb 16 17:32:01 0097 BC | -10 | -1 | -1 | 1686043
- Sat Feb 16 17:32:01 0097 | 9 | 1 | 1 | 1756537
- Thu Feb 16 17:32:01 0597 | 59 | 6 | 1 | 1939158
- Tue Feb 16 17:32:01 1097 | 109 | 11 | 2 | 2121779
- Sat Feb 16 17:32:01 1697 | 169 | 17 | 2 | 2340925
- Thu Feb 16 17:32:01 1797 | 179 | 18 | 2 | 2377449
- Tue Feb 16 17:32:01 1897 | 189 | 19 | 2 | 2413973
- Sun Feb 16 17:32:01 1997 | 199 | 20 | 2 | 2450497
- Sat Feb 16 17:32:01 2097 | 209 | 21 | 3 | 2487022
- Wed Feb 28 17:32:01 1996 | 199 | 20 | 2 | 2450143
- Thu Feb 29 17:32:01 1996 | 199 | 20 | 2 | 2450144
- Fri Mar 01 17:32:01 1996 | 199 | 20 | 2 | 2450145
- Mon Dec 30 17:32:01 1996 | 199 | 20 | 2 | 2450449
- Tue Dec 31 17:32:01 1996 | 199 | 20 | 2 | 2450450
- Wed Jan 01 17:32:01 1997 | 199 | 20 | 2 | 2450451
- Fri Feb 28 17:32:01 1997 | 199 | 20 | 2 | 2450509
- Sat Mar 01 17:32:01 1997 | 199 | 20 | 2 | 2450510
- Tue Dec 30 17:32:01 1997 | 199 | 20 | 2 | 2450814
- Wed Dec 31 17:32:01 1997 | 199 | 20 | 2 | 2450815
- Fri Dec 31 17:32:01 1999 | 199 | 20 | 2 | 2451545
- Sat Jan 01 17:32:01 2000 | 200 | 20 | 2 | 2451546
- Sun Dec 31 17:32:01 2000 | 200 | 20 | 2 | 2451911
- Mon Jan 01 17:32:01 2001 | 200 | 21 | 3 | 2451912
+ timestamp | decade | century | millennium | julian | epoch
+-----------------------------+-----------+-----------+------------+-----------+--------------
+ -infinity | -Infinity | -Infinity | -Infinity | -Infinity | -Infinity
+ infinity | Infinity | Infinity | Infinity | Infinity | Infinity
+ Thu Jan 01 00:00:00 1970 | 197 | 20 | 2 | 2440588 | 0
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:02 1997 | 199 | 20 | 2 | 2450491 | 855595922
+ Mon Feb 10 17:32:01.4 1997 | 199 | 20 | 2 | 2450491 | 855595921.4
+ Mon Feb 10 17:32:01.5 1997 | 199 | 20 | 2 | 2450491 | 855595921.5
+ Mon Feb 10 17:32:01.6 1997 | 199 | 20 | 2 | 2450491 | 855595921.6
+ Thu Jan 02 00:00:00 1997 | 199 | 20 | 2 | 2450451 | 852163200
+ Thu Jan 02 03:04:05 1997 | 199 | 20 | 2 | 2450451 | 852174245
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Tue Jun 10 17:32:01 1997 | 199 | 20 | 2 | 2450611 | 865963921
+ Sat Sep 22 18:19:20 2001 | 200 | 21 | 3 | 2452176 | 1001182760
+ Wed Mar 15 08:14:01 2000 | 200 | 20 | 2 | 2451619 | 953108041
+ Wed Mar 15 13:14:02 2000 | 200 | 20 | 2 | 2451620 | 953126042
+ Wed Mar 15 12:14:03 2000 | 200 | 20 | 2 | 2451620 | 953122443
+ Wed Mar 15 03:14:04 2000 | 200 | 20 | 2 | 2451619 | 953090044
+ Wed Mar 15 02:14:05 2000 | 200 | 20 | 2 | 2451619 | 953086445
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:00 1997 | 199 | 20 | 2 | 2450491 | 855595920
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Tue Jun 10 18:32:01 1997 | 199 | 20 | 2 | 2450611 | 865967521
+ Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
+ Tue Feb 11 17:32:01 1997 | 199 | 20 | 2 | 2450492 | 855682321
+ Wed Feb 12 17:32:01 1997 | 199 | 20 | 2 | 2450493 | 855768721
+ Thu Feb 13 17:32:01 1997 | 199 | 20 | 2 | 2450494 | 855855121
+ Fri Feb 14 17:32:01 1997 | 199 | 20 | 2 | 2450495 | 855941521
+ Sat Feb 15 17:32:01 1997 | 199 | 20 | 2 | 2450496 | 856027921
+ Sun Feb 16 17:32:01 1997 | 199 | 20 | 2 | 2450497 | 856114321
+ Tue Feb 16 17:32:01 0097 BC | -10 | -1 | -1 | 1686043 | -65192711279
+ Sat Feb 16 17:32:01 0097 | 9 | 1 | 1 | 1756537 | -59102029679
+ Thu Feb 16 17:32:01 0597 | 59 | 6 | 1 | 1939158 | -43323575279
+ Tue Feb 16 17:32:01 1097 | 109 | 11 | 2 | 2121779 | -27545120879
+ Sat Feb 16 17:32:01 1697 | 169 | 17 | 2 | 2340925 | -8610906479
+ Thu Feb 16 17:32:01 1797 | 179 | 18 | 2 | 2377449 | -5455232879
+ Tue Feb 16 17:32:01 1897 | 189 | 19 | 2 | 2413973 | -2299559279
+ Sun Feb 16 17:32:01 1997 | 199 | 20 | 2 | 2450497 | 856114321
+ Sat Feb 16 17:32:01 2097 | 209 | 21 | 3 | 2487022 | 4011874321
+ Wed Feb 28 17:32:01 1996 | 199 | 20 | 2 | 2450143 | 825528721
+ Thu Feb 29 17:32:01 1996 | 199 | 20 | 2 | 2450144 | 825615121
+ Fri Mar 01 17:32:01 1996 | 199 | 20 | 2 | 2450145 | 825701521
+ Mon Dec 30 17:32:01 1996 | 199 | 20 | 2 | 2450449 | 851967121
+ Tue Dec 31 17:32:01 1996 | 199 | 20 | 2 | 2450450 | 852053521
+ Wed Jan 01 17:32:01 1997 | 199 | 20 | 2 | 2450451 | 852139921
+ Fri Feb 28 17:32:01 1997 | 199 | 20 | 2 | 2450509 | 857151121
+ Sat Mar 01 17:32:01 1997 | 199 | 20 | 2 | 2450510 | 857237521
+ Tue Dec 30 17:32:01 1997 | 199 | 20 | 2 | 2450814 | 883503121
+ Wed Dec 31 17:32:01 1997 | 199 | 20 | 2 | 2450815 | 883589521
+ Fri Dec 31 17:32:01 1999 | 199 | 20 | 2 | 2451545 | 946661521
+ Sat Jan 01 17:32:01 2000 | 200 | 20 | 2 | 2451546 | 946747921
+ Sun Dec 31 17:32:01 2000 | 200 | 20 | 2 | 2451911 | 978283921
+ Mon Jan 01 17:32:01 2001 | 200 | 21 | 3 | 2451912 | 978370321
(65 rows)
-- TO_CHAR()
generated by cgit v1.2.3 (git 2.39.1) at 2025-12-22 02:46:36 +0000