Get the first day of the month
Quickly returns the
first day of current month. Instead of current month you want to find first day
of month where a date falls, replace SYSDATE with any date column/value
SELECT TRUNC (SYSDATE, 'MONTH') "First day of current month" FROM DUAL
