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.
Gregorian Date to Hijri
Moderators: chulett, rschirm, roy
Gregorian Date to Hijri
Thanks And Regards,
dinthat
dinthat
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.