Page 1 of 1
Gregorian Date to Hijri
Posted: Sun Mar 30, 2008 3:28 am
by dinthat
Hi All,
In my job, the input is Gregorian date, I want to convert it into corresponding Hijri date. Can anybody suggest a method to do this.
Posted: Sun Mar 30, 2008 4:34 am
by ArndW
No, unfortunately not. I checked up on the Server NLS functionality as well, since there is support for Japanese and Chinese calendars but as those are based 1:1 on the Gregorian they are easier than the Hijri calendar.
There are a number of public-domain c++ routines floating around the internet, so in this case you can build your own DataStage PX buildop or function to do this conversion.
Posted: Sun Mar 30, 2008 4:47 am
by ray.wurlod
Yes, it can be done, but is not direct. It may be that a database to which you are connecting has a function (for example Oracle does) that you can use. Otherwise search the internet for how to code the conversion.