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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br