diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/horology.out | 13 | ||||
| -rw-r--r-- | src/test/regress/sql/horology.sql | 3 |
2 files changed, 16 insertions, 0 deletions
diff --git a/src/test/regress/expected/horology.out b/src/test/regress/expected/horology.out index 26d7541b720..b13f7d7c5b5 100644 --- a/src/test/regress/expected/horology.out +++ b/src/test/regress/expected/horology.out @@ -264,6 +264,19 @@ SELECT time with time zone 'T040506.789 -08'; (1 row) SET DateStyle = 'Postgres, MDY'; +-- Check Julian dates BC +SELECT date 'J1520447' AS "Confucius' Birthday"; + Confucius' Birthday +--------------------- + 09-28-0551 BC +(1 row) + +SELECT date 'J0' AS "Julian Epoch"; + Julian Epoch +--------------- + 11-24-4714 BC +(1 row) + -- -- date, time arithmetic -- diff --git a/src/test/regress/sql/horology.sql b/src/test/regress/sql/horology.sql index 615755e3de0..97ff9f20c79 100644 --- a/src/test/regress/sql/horology.sql +++ b/src/test/regress/sql/horology.sql @@ -56,6 +56,9 @@ SELECT time with time zone 'T040506.789-08'; SELECT time with time zone 'T040506.789 +08'; SELECT time with time zone 'T040506.789 -08'; SET DateStyle = 'Postgres, MDY'; +-- Check Julian dates BC +SELECT date 'J1520447' AS "Confucius' Birthday"; +SELECT date 'J0' AS "Julian Epoch"; -- -- date, time arithmetic |