Need to find month number in current quarter for each year in oracle sql. For example let's today is 8/3/2017 so the sql select statement using dual and sysdate should give Year: 2017 Quarter: Q3 and Current Quarter Month Number: 2. Another example let's say today's date is 12/23/2017 then Year: 2017, Current Quarter: 4 and Current Quarter Month Number: 3