Please anybody can help me to convert Islamic Hijri Date to Gregorian Date in Oracle, I need to retreive the full age like "24 Years and 3 Months" on the base of column Birth_Date the problem is in my column Birth_date I have many dates in Hijri and Many in Gregorian in the column please help me know how to convert these Hijri Dates into Gregorian.



Thanks