According to http://psoug.org/reference/date_func.html, this should work a dandy…
SELECT TRUNC(yourDateField, 'MONTH') FROM yourTable
According to http://psoug.org/reference/date_func.html, this should work a dandy…
SELECT TRUNC(yourDateField, 'MONTH') FROM yourTable