Hi All,
to_char(sysdate,'IW') gives a week number in a year based on jan - dec calendar. Jan 1st week will be 1, jan 2nd week 2 and so on..
my requirement is calendar should consider based on Jul - Jun calendar i.e., July 1st week should be return as 1, second week should return as 2 and so on.... how do I achieve this? Is there any function related to fiscal calendar year?
Many thanks,