This content has been marked as final. Show 4 replies
I think it depends upon you NLS setting, did you tried with that , what you got ?
Convert to hirjih date using:
to_char(sysdate,'YYYY/MM/DD','NLS_CALENDAR=''English Hijrah''') hijrih_date
You can replace sysdate with the date of your choice.
Also I wrote this for my last project:
/* get hirjih date */
p_date in date,
p_date_format in varchar2
) return varchar2
So you can have get_hijrah_date(sysdate,'DD-MON-YYYY') from dual;
(or any other date formate of your choice)
Edited by: igwe on Jan 30, 2013 8:07 AM
HI....Looks simple and great
If you are satisfied with the answer, please mark it as answered so that it helps other people too.