Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to calculate Financial year from current sysdate

User_A33LNDec 18 2021

select add_months(trunc(sysdate,'yyyy'),3) statrt_date , add_months(add_months(trunc(sysdate,'yyyy'),3),12)-1 end_date from dual
but this condition valid through jan to dec while next year jan change day so how to handled

Comments
Post Details
Added on Dec 18 2021
2 comments
6,223 views