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
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


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?


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

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: Sun Jul 23 16:06:25 CDT 2017

Total time taken to generate the page: 0.13431 seconds