Hi Experts,

I wanted help with converting Hijri Date to Gregorian Date and visa
versa in Sybase.

A lot of googling helped me find how to do it in Oracle,

select to_char(sysdate,'DD/MM/YYYY','NLS_CALENDAR=''Arabic
Hijrah''') ,to_char(sysdate,'DD/MM/
YYYY','NLS_CALENDAR=''Gregorian''')
from dual

If any one has any clue how it can be done in Sybase will be greatly
appreciated.

Cheers,
Rosh

On Thursday, July 12, 2012 12:16:38 AM UTC-6, Rosh wrote:
There is nothing direct built-in at this time. The easiest way
to do it would probably be to enable the ASE Java feature and import
a Java class that can do the conversion. I found several
possible implementations via google without any trouble.

-bret

On Friday, July 13, 2012 10:53:38 PM UTC+3, br... (AT) sybase (DOT) com wrote:
Thanx for the reply Bret... Enabling Java is not an option for us...
can u throw some more light on " I found several
possible implementations via google without any trouble"

Searching Google for "hijri java gregorian" produced several
hits on sites that appear to be offering Java code for doing the conversion.


Cheers,
-bret