Tabular Islamic calendar
The Tabular Islamic calendar (an example is the Fatimid or Misri calendar) is a rule-based variation of the Islamic calendar. It has the same numbering of years and months, but the months are determined by arithmetical rules rather than by observation or astronomical calculations. It was developed by early Muslim astronomers of the second hijra century (the 8th century of the Common Era) to provide a predictable time base for calculating the positions of the moon, sun, and planets. It is now used by historians to convert an Islamic date into a Western calendar when no other information (like the day of the week) is available.
It is used by some Muslims in everyday life, particularly in Ismaili communities, believing that this calendar was developed by Ali. It is believed that when Ali drew up this calendar, the previous events of the earlier prophets also fell into line with this calendar. It is their belief that all Fatimid Imams and their Da'is have followed this tradition.
Each year has 12 months. The odd numbered months have 30 days and the even numbered months have 29 days, except in a leap year when the 12th and final month Dhul-Hijjah has 30 days.
In its most common form there are 11 leap years in a 30-year cycle. Noting that the average year has 354 11/30 days and a common year has 354 days, at the end of the first year of the 30-year cycle the remainder is 11/30 day. Whenever the remainder exceeds a half day (15/30 day), then a leap day is added to that year, reducing the remainder by one day. Thus at the end of the second year the remainder would be 22/30 day which is reduced to −8/30 day by a leap day. Using this rule the leap years are
- 2, 5, 7, 10, 13, 16, 18, 21, 24, 26 and 29
of the 30-year cycle. If leap days are added whenever the remainder equals or exceeds a half day, then all leap years are the same except 15 replaces 16.
- 2, 5, 8, 10, 13, 16, 19, 21, 24, 27 and 29
Apart from these, there is another version which orders the leap years as follows
- 2, 5, 8, 11, 13, 16, 19, 21, 24, 27 and 30
The mean month is 29 191/360 days = 29.5305555... days, or 29d 12h 44m. This is slightly too short and so will be a day out in about 2500 years. The Tabular Islamic calendar also deviates from the observation based calendar in the short term for various reasons.
The "Kuwaiti algorithm" is used by Microsoft to convert between Gregorian calendar dates and Islamic calendar dates. There is no fixed correspondence defined in advance between the Gregorian solar calendar and the Islamic lunar calendar, since the latter is defined by the visibility of the new moon by religious authorities and can therefore vary by a day or two, depending on the particular Islamic authority, weather conditions, and other variables. As an attempt to make conversions between the calendars somewhat predictable, Microsoft claims to have created this algorithm based on statistical analysis of historical data from Kuwait.
According to Robert Harry van Gent at Utrecht University, the so-called "Kuwaiti algorithm" is simply an implementation of a standard Tabular Islamic calendar algorithm used in Islamic astronomical tables since the 11th century.
Tabular Islamic calendars based on an eight - year cycle (with 2, 5 and 8 as leap years) were also used in the Ottoman Empire and in South-East Asia. The cycle contains 96 months in 2835 days, giving a mean month length of 29.53125 days, or 29d 12h 45m. Though less accurate than the tabular calendars based on a 30-year cycle, it was popular due to the fact that in each cycle the weekdays fall on the same calendar date. In the Dutch East Indies the cycle was reset every 120 years by omitting the intercalary day at the end of the last year, thus resulting in a mean month length equal with that used in the 30-year cycles.
- Hijri Dates in SQL Server 2000 from Microsoft Archived Page Archived January 8, 2010, at the Wayback Machine.
- Kriegel, Alex, and Boris M. Trukhnov. SQL Bible. Indianapolis, IN: Wiley, 2008. Page 383.
- "Microsoft gives no details on the mathematics of the “Kuwaiti Algorithm” but one can easily demonstrate that it is based on the standard arithmetical scheme (type IIa) which has been used in Islamic astronomical tables since the 11th century CE. Naming this algorithm the “Kuwaiti Algorithm” is thus historically incorrect and should be discontinued." Islamic-Western Calendar Converter (Based on the Arithmetical or Tabular Calendar)
- Ian Proudfoot, Old Muslim Calendars of Southeast Asia (Leiden: Brill, 2006 [= Handbook of Oriental Studies, Section 3, vol. 17]).
- G.P. Rouffaer, "Tijdrekening", in: Encyclopaedie van Nederlandsch-Indië (The Hague/Leiden: Martinus Nijhoff/E.J. Brill, 1896–1905), vol. IV, pp. 445–460 (in Dutch).
- Islamic-Western Calendar Converter (Based on the Arithmetical or Tabular Calendar) – includes all four known variants
- Online Alavi Taiyebi Calendar
- Calendar Converter