Client wants to calculate age based on hiji dates. Date of birth is in 'Gregorian' . Any help?

Does the following site help at all?

http://ksadba.wordpress.com/2008/06/25/c...oracle-to_date/

Or discussion: http://www.orafaq.com/forum/t/150700/2/

result is:

select to_char(to_date('13/11/1956','DD/MM/YYYY','NLS_CALENDAR=''Gregorian'''),
'DD MONTH YYYY','NLS_CALENDAR=''English Hijrah''') "13/11/1956 is" from dual;

Will need to do the Math to calculate the Age from that.

Hope this gets you closer to where you need to go!

Gavin