nowbotstorm

The tables below list equivalent dates in the Julian and Gregorian calendars. Years are given in astronomical year numbering.

• Convert Julian Date To Gregorian

How can I create a UDF which convert the Solar Date '1386/9/10' to Georgian Date '2007/12/01'. Thnx Last edited by shg; December 9th, 2007, 06:05. Convert Solar Date To Gregorian Date OK, look at the descriptions and examples in the first three functions below. This script creates a calendar converter that can convert five different units at one time; that is actually converting between the Gregorian Calendar, Julian Calendar and Julian Date, and translating those into the Roman and Latin versions of the Julian Calendar. Convert Julian date to Gregorian date – Learn more on the SQLServerCentral forums. I am trying to convert Julian dates to gregorian dates in sql server but Julian date column has invalid.

Conventions[edit]

• Within these tables, January 1 is always the first day of the year.
• The Gregorian calendar did not exist before October 15, 1582. Gregorian dates before that are proleptic, that is, using the Gregorian rules to reckon backward from October 15, 1582.
• Years are given in astronomical year numbering.
• Augustus corrected errors in the observance of leap years by omitting leap days until AD 8. Julian calendar dates before March AD 4 are proleptic, and do not necessarily match the dates actually observed in the Roman Empire. (Nautical almanac offices of the United Kingdom and United States, 1961, p. 411)

Conversion table[edit]

This table is taken from the book by the Nautical almanac offices of the United Kingdom and United States originally published in 1961.^[1]

Using the tables[edit]

Convert Julian Date To Gregorian

Dates near leap days that are observed in the Julian calendar but not in the Gregorian are listed in the table. Dates near the adoption date in some countries are also listed. For dates not listed, see below.

The usual rules of algebraic addition and subtraction apply; adding a negative number is the same as subtracting the absolute value, and subtracting a negative number is the same as adding the absolute value.

If conversion takes you past a February 29 that exists only in the Julian calendar, then February 29 is counted in the difference. Years affected are those which divide by 100 without remainder but do not divide by 400 without remainder (e.g., 1900 and 2100 but not 2000).

No guidance is provided about conversion of dates before March 5, -500, or after February 29, 2100 (both being Julian dates).

For unlisted dates, find the date in the table closest to, but earlier than, the date to be converted. Be sure to use the correct column. If converting from Julian to Gregorian, add the number from the 'Difference' column. If converting from Gregorian to Julian, subtract.

1. ^H M Nautical Almanac Office (1974). Explanatory Supplement to the Astronomical Ephemeris. London. pp. 416–18.

See also[edit]

References[edit]

• Nautical almanac offices of the United Kingdom and United States. (1961). Explanatory Supplement to the Astronomical Ephemeris and the American Ephemeris and Nautical Almanac (pp. 410–18 ). London: H. M. Stationery Office.

External links[edit]

I want to convert Hijri date to Gregorian date!I've searched, but unfortunately I found a java class for converting Gregorian to Hijri. I need the opposite.

HijriCalendar.java: https://gist.github.com/fatfingers/6492017

2 Answers

You can use Joda-Time for this.

If you create an Islamic cronology and call withUTC() it should return an UTC cronology which can be converted to whatever is needed.

However, according to this post, the joda-Time implementation is only an approximation.

The formula to convert Muslim (M) dates to CE is:

CE = ((M x 970224)/1000000)+ 621.5774 = CE.nnn

then 0.nnn x 365 = day of the CE year M year began.

From that you can determine the day you are looking for from the Muslim month chart:

1. Muharram = 30 days;
2. Safar = 29 days;
3. Rabia 1 = 30 days;
4. Rabia 2 = 29 days;
5. Jumada 1 = 30 days;
6. Jumada 2 = 29 days;
7. Rajab = 3 days;
8. Shaban = 29 days;
9. Ramadan = 30 days;
10. Shawwal = 29 days;
11. Zu'lKadah = 30 days;
12. Zu'lhijjah = 29 days (30 days if leap year).

Years run in 30 year cycles.

Each cycle starts on 15 June. The 2nd, 5th, 7th, 10th, 13th, 16th, 18th, 21st, 24th 26th and 29th are leap years.

One cycle = 10, 631 days.

Hope this helps. I also have the formula for converting CE dates to Muslim dates.

Not the answer you're looking for? Browse other questions tagged javaandroidhijri or ask your own question.