Hi guyz,
Anyone help me to solve this problem plz.
i have a table contain the fields
hijri_isu_date,hijri_exp_date,geo_isu_date,geo_exp_date,
Geo = GREGORIAN
i want to do this following when when ever i call this form is should set the nls_calender to arabic hijrah in pre_form trigger if im not wrong i can use the below code?
forms_ddl('alter session set nls_calendar=''Arabic Hijrah''');
and when user enter date in hijri_isu_date and hijri_exp_date it will convert to gregorian date automatically according to hijri date as per user entered.
anyone explain me plz how can i do this convertion?
Regards
Moazam