Dear All,
I have a SQL like below:
Select statusdate, statusdate_gregorian, status from status_table;
My DB is in Arabic, when I read statusdate as above from DB it returns me Hijri date as default. In second column I need date in gregorian date for which I have one table Calender which is mapped with Gregorian and Hijri dates. Can I use decode command in SELECT and apply it on table when I give hijri date it returns me Gregorian date? Or any other solution.
Your help will highly be appreciated.