how to write Oracle Function For Convert Date to persian (jalali)

i want to convert date to Persian date (jalali) in oracle Database
there is any function ?

You can use this statement:

select to_char(hiredate,'yyyy/mm/dd','nls_calendar=persian') from emp

`hiredate` is a date field, with this select `hiredate` is displayed in persian

First of all you must set `nls_calendar` to Persian like below:

Alter session set nls_calendar=persian;

Now you can change format of date like below:

Select to_char(sysdate,'yyyy/mm/dd') from dual;