How to write a select query for financial year? The financial is from 1st July to 30th June each year. Here’s the pseudo code (dd-mm-yyyy):
If extract(month from current_date) < 7 then
select date between (‘01-07-date_part(‘year’, current_date)’-1) and (‘30-06-date_part(‘year’, current_date’)
else
select date between (‘01-07-date_part(‘year’, current_date)’) and (‘30-06-date_part(‘year’, current_date’)
End if;
Appreciate any help.