All quarters in current year in Oracle SQL

Question

I want to display the quarters in the current year like -

Is there any way to do this ? When I am using the below query, I am only getting current quarter -

select to_char(sysdate, 'yyyy" Q "q') as QuaterDate from dual

score 5 · Answer 1 · answered May 04 '22 at 06:50

5

Just for fun:

select to_char(sysdate, 'yyyy" Q "') || xmlcast(column_value as number) as qtr
from   xmltable('1 to 4')
;

QTR     
--------
2022 Q 1
2022 Q 2
2022 Q 3
2022 Q 4

answered May 04 '22 at 06:50

score 3 · Accepted Answer · edited May 04 '22 at 06:50

3

You can use a hierarchical query such as

 SELECT TO_CHAR(sysdate, 'yyyy" Q "')||level AS QuaterDate 
   FROM dual
CONNECT BY level <= 4

edited May 04 '22 at 06:50

answered May 04 '22 at 06:04

Barbaros Özhan

59,113
10
31
55

All quarters in current year in Oracle SQL

2 Answers2