convert hijri to gregorian oracle

Posted on by

convert hijri to gregorian oracle

convert hijri to gregorian oracle by use sql at below syntax

SELECT TO_CHAR(SYSDATE, ‘DD-MM-YYYY’, ‘NLS_CALENDAR=”English Hijrah”’) FROM DUAL

select TO_DATE(’24/08/1439′,’dd/mm/yyyy’,q'[nls_calendar=’English Hijrah’]’) from dual

 

Ref:docs.oracle.com/cd/B19306_01/server.102/b14237/initparams119.htm#REFRN10116

Posted in SQL.