CODEWITHSUNDEEP
sqloracle-databaseoracle19c
Anirban Chakraborty
Anirban Chakraborty

Reputation: 781

How to get the quarter corresponding to a date in Oracle SQL 19c

I think there was a function extract(quarter from date) in oracle sql to fetch the quarter for a given date. However the Oracle SQL 19c documentation here does not show the presence of quarter anymore.

I even tried running the code -

select extract(quarter from to_date('15/09/2021','DD/MM/YYYY')) as Q from dual;

The expected result is -

+---+
|  Q|
+---+
|  3|
+---+

Instead it gives an error

ORA-00907 missing right parenthesis

though it runs fine when quarter is replaced by month or year. What is the current way to fetch quarter given a date in Oracle SQL 19c?

Upvotes: 6

Views: 27751

Answers (1)

user5683823
user5683823

Reputation:

I will use sysdate for illustration - you can replace that with any expression of date data type.

The query returns a string (of a single character, a digit between 1 and 4); if you need a number value, wrap it within to_number().

select to_char(sysdate, 'Q') as qtr from  dual;

QTR
---
3

Upvotes: 13

Related Questions