Query for Add Months

deb_84 · #1 (**permalink**) 11-10-11, 06:39

I want to find out the count for number of transactions that exists for a quarter{ i.e for three months JAN,FEB,MARCH}. I am using TO_CHAR(ADD_MONTHS(SYSDATE, -2), 'ddMONyyyy') for get the difference.

For Example SYSDATE is 31st March and then the run the above query. It will give me result as 31st Jan. But i want it from 1st Jan. How will i get the transactions for the remaining days.

shammat · #2 (**permalink**) 11-10-11, 07:58

You should have posted this to the Oracle forum, as this is not ANSI SQL.

You can use Oracle's built-in "Quarter" Calculation for this:

Code:

SELECT *
FROM your_table
WHERE extract(year from sysdate) = extract(year from your_date_column)
AND to_char(sysdate, 'Q') = to_char(your_date_column, 'Q')

deb_84 · #3 (**permalink**) 11-11-11, 01:07

Thanks a lot!!!! It's working now with your code

Internet Services

Web Development

Digital Marketing

Consumer Tech