Subject Re: [firebird-support] gregorian to hijri
Author Alexandre Benson Smith
Z T Minhas wrote:
> Hi,
> Does anyone have a SQL statement that can convert Gregorian dates to Hijri?
> I have something like this in Oracle:
> select to_char(sysdate,'DD MONTH YYYY','NLS_CALENDAR=''Arabic Hijrah''') from dual;
> what about in Firebird?
> Regards
> Zafar

I don't know how to convert one calendar to another, but FB does not
have it built-in... Perhaps it's easy to do it using only SQL.

But my advice is to code yourself an UDF to do it.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil