Functions for Gregorian to Hijrah and Hijrah to Gregorian

HIJRAH TO GREGORIAN
--------------------------------------
Syntax: 
to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(<VALUE>), 'YYYY/MM/DD')

eg:
SELECT to_date(hr_sa_hijrah_functions.hijrah_to_gregorian('1433/08/30'), 'YYYY/MM/DD')Greg_date FROM DUAL;



Output: 7/20/2012

GREGORIAN TO HIJRAH
--------------------------------------
Syntax:
to_char(to_date(<VALUE>,'mm/dd/yyyy'),'yyyy/mm/dd','nls_calendar=''Arabic Hijrah''')

eg:
SELECT to_char(to_date('10/30/2012','mm/dd/yyyy'),'yyyy/mm/dd','nls_calendar=''Arabic Hijrah''')hijrah_date FROMDUAL;