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!

covert date to fiscal date

slider rulesOct 30 2018 — edited Oct 31 2018

Hi,

I am using Oracle 11.2.0.4 database and had a query on how to convert a date to fiscal date, this is based on the financial year running from Apr-Mar

The year in the date format would change to fiscal

For example(dd/mm/yyyy)

Current Date Required Result

01/05/2018 = 01/05/2019

31/12/2019 = 31/12/2020

01/01/2016 = 01/01/2016

31/03/2020 = 31/03/2020

04/04/2030 = 04/04/2031

Can you suggest a function to achieve the above result

Thanks

This post has been answered by mathguy on Oct 30 2018

Jump to Answer

Added on Oct 30 2018

11 comments

2,549 views