Skip to content

Instantly share code, notes, and snippets.

@marschall

marschall/oracle_calendar.sql

Created August 2, 2019 08:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save marschall/69b72f7519905b6a050ad99d82366578 to your computer and use it in GitHub Desktop.
Save marschall/69b72f7519905b6a050ad99d82366578 to your computer and use it in GitHub Desktop.
Download ZIP
Shows the Oracle calendar is not proleptic
Raw
oracle_calendar.sql
WITH calendar(date_value) AS (
SELECT TIMESTAMP '1582-09-30 00:00:00'
FROM dual
UNION ALL
SELECT date_value + 1
FROM calendar
WHERE date_value <= TIMESTAMP '1582-10-16 00:00:00'
)
SELECT date_value
FROM calendar;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment