This is the blog dedicated to Oracle Applications users. Here I will be posting information on Oracle Application which will have technical related topics. Although the site may be more beneficial to technial junkies. Please remember to visit site regularly as it will be updated quite often and do remember to encourage me by posting your valuable comments. Thanks and Regards Dilli Subramani
Tuesday, 8 April 2014
get financial year from a date in oracle
SELECT EXTRACT (YEAR FROM ADD_MONTHS (SYSDATE, -3))
|| '-'
|| EXTRACT (YEAR FROM ADD_MONTHS (SYSDATE, 9))
FROM DUAL;
No comments:
Post a Comment