Saturday, May 28, 2022

4 fiscal quarters in oracle sql

 SELECT to_char( add_months( '&report_date_', 7 ), 'YYYY' ) fiscal_year,

       'Q'||to_char( add_months( '&report_date_', 7 ), 'Q' ) fiscal_quarter

  FROM dual;

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/