Home » Developer & Programmer » Forms » Hijri Dates (Windows XP DB 9i - forms 6i)
Hijri Dates [message #385249] Sun, 08 February 2009 08:19 Go to next message
*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

Re: Hijri Dates [message #385500 is a reply to message #385249] Mon, 09 February 2009 23:11 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'hijri'. Also, try the whole site.

David
Previous Topic: Can we open 2 session simultaneously(Oracle Forms 10g)
Next Topic: How to know if user has updated a field...
Goto Forum:
  


Current Time: Fri Dec 02 22:34:21 CST 2016

Total time taken to generate the page: 0.11890 seconds