I need to generate a report for the number of accounts opened in the duration of one month.
I tried a query
SELECT COUNT(*) FROM Table1 A
WHERE ((MONTHS_BETWEEN('<express1>',A.ISS_DATE))) BETWEEN 0 AND 1
The query works fine but when i give <expression1> as '2005-12-31', it retuns the rows with date 30-11-2005 also.
I mean if I am running the report at 31st December then i should get the records from 1st of December and not from 30th November.
Please ignore my ignorance and guide me in how to approach.