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 sort by Month when Using Fiscal Year

FriendlyToooNov 16 2019 — edited Nov 17 2019

Hi Folks:

Our fiscal Year runs from 10/01/2019 to 09/30/2020.     I have no problem filtering the data by fiscal year.

The problem is that the months are still sorted by 01 (Jan)  to 12 (December).   I'd like to sort the calendar so that October is the first month, and September the last.

Is there a way to do this in the Order by clause?

Thanks for any help ...

matthew

Comments
Post Details
Added on Nov 16 2019
4 comments
3,026 views