Oracle SQL: Return a character string for the first day of the current month (substitute any date field/value for SYSDATE if other months are needed).
--Return the first day of the current month in MM/DD/YYYY format
TO_CHAR(TRUNC(LAST_DAY(ADD_MONTHS(SYSDATE,-1))+1),'MM/DD/YYYY')