Dear,
I think below result of query is a bug Persian date at oracle database 11g.
--
select
To_DATE(TO_CHAR(to_date('1390/10/30','yyyy/mm/dd'),'YYYY/MM/DD','nls_calendar=persian'),'YYYY/MM/DD','nls_calendar=persian') - To_DATE(TO_CHAR(to_date('1389/11/01','yyyy/mm/dd'),'YYYY/MM/DD','nls_calendar=persian'),'YYYY/MM/DD','nls_calendar=persian') dd
from dual
The Result = 364
---
This result is wrong,so the correct answer must be "365".How can I solve it?
Best regards,
Saeed.