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.

Advertisements

One thought on “Julian to Gregorian Calender Switch impact on Oracle

  1. 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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s