Data in SQL ORACLE

Question

How do I apply a function in ORACLE SQL that brings me only records for the current month? BS.: I have a date column in date format (e.g.: 13/09/18).

In sql server I applied the function below and worked perfectly:

DAT_REFERENCIA>= DATEADD(MM,DATEDIFF(MM,0,GETDATE())-0,0)

Answer 1

You can use WHERE like this:

WHERE trunc( DAT_REFERENCIA, 'MM' ) = trunc( sysdate, 'MM' )

Will take the current date of sysdate (as getdate() in the sql-server)

EDIT: To take the current and previous month, you can use the between:

WHERE DAT_REFERENCIA BETWEEN  add_months(trunc(sysdate,'MM'),-1) AND SYSDATE

Answer 2

Friend, use the function EXTRACT for the command that takes the current date in Oracle which is the sysdate. Below is an example:

Select extract(month from sysdate) as MES_ATUAL from dual ;