Julian to Gregorian Calender Switch impact on Oracle

Do you see something abnormal in following image?

oct-1582

Yes …….what’s this ……?

And same thing you will see on some other ERP solutions / software once you select September 1752.

Answer

The calendar snippet shows that there are no days between October 4 and October 15. This discontinuity is called the “cutover”.

What is Cutover

“This is a hybrid Julian/Gregorian calendar with a cutover on October 4/15 1582.” Any dates before a cutover are Julian, any dates during a cutover are nonexistent, and any dates after a cutover are Gregorian.

One Response to “Julian to Gregorian Calender Switch impact on Oracle”

  1. Laurent Schneider Says:

    as expected :
    select date ‘1582-10-15′ – date ‘1582-10-04′ from dual
    1

    (only one day)

    a bit more surprising :
    select date ‘1582-10-15′ – date ‘1582-10-14′ from dual
    -9

    date ‘1582-10-14′ is an inexistent date that translate to “10 days after 4-OCT-1582″

    ;)


Leave a Reply