SELECT of month/year in DATES

Question

I need select to return all the rows that were inserted in July 2010, as shown in the example, regardless of the day. How to return this query?

SELECT * FROM FRCAST 
WHERE DATA_ID = TO_CHAR('07-2010', 'mm-yyyy');

Answer 1

You can use the function EXTRACT to test pieces of a date. Your query would look like this:

SELECT * FROM FRCAST 
WHERE extract(month from DATA_ID) = 7 and extract (year from DATA_ID) = 2010;

Answer 2

You can also use the BETWEEN:

SELECT * FROM FRCAST 
WHERE DATA_ID between 
TO_DATE('01/07/2010','DD/MM/YYYY') and 
TO_DATE('31/07/2010 23:59:59','DD/MM/YYYY HH24:mi:ss');

Answer 3

To make this query, you can do as follows:

SELECT * FROM FRCAST
WHERE TO_CHAR(DATA_ID,'MM-YYYY')='07-2010';

_{References:
How to select Rows for a specific Month
TO_CHAR (datetime)}

Answer 4

SELECT * FROM FRCAST 
WHERE  TO_CHAR(DATA_ID, 'mm-yyyy') ='07-2010'