General Development Discussions

Hi,

Form 6i,

Oracle 11.2.0.4 , windows server 2016

I need to convert gregorian date to hijri date.

I have two date fields for Gregorian and Hijri.

I select date in gregorian field using calendar and the format is DD-MON-YYYY.

in when validate item on gregorian field, i am using below code

Select To_Date(To_Char(TO_DATE(:supplier.sup_cr_expiry,'DD-MM-YYYY','Nls_Calendar = '''||'Gregorian'''), 'DD-MM-YYYY',
'Nls_Calendar = '''||'Arabic Hijrah'''), 'DD-MM-YYYY') into :supplier.sup_cr_expiry_hijri
from Dual;

i get error ORA-01841.

Please suggest any solution