OraFAQ Forum: Forms » Hijri Dates

Home » Developer & Programmer » Forms » Hijri Dates (Windows XP DB 9i - forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Hijri Dates [message #385249]

Sun, 08 February 2009 08:19

*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh

Senior Member

Hi guyz,

Anyone help me to solve this problem plz.

i have a table contain below 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 please how can i do this convertion?

Regards

Report message to a moderator