Programmers Lounge
Thursday, August 25, 2011
Get Financial Year Week no for given date
Financial Week start from 01-Apr each year. So for 01-Apr of that year i should get week number as 1.
select
to_char(SYSDATE) the_date,
to_char(add_months(SYSDATE,-3),'WW') fiscal_week
from dual
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment