Gregorian Date to Hijri

dinthat · Post by **dinthat** » Sun Mar 30, 2008 3:28 am

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.

ArndW · Post by **ArndW** » Sun Mar 30, 2008 4:34 am

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.

ray.wurlod · Post by **ray.wurlod** » Sun Mar 30, 2008 4:47 am

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.