23maverick23
10/31/2013 - 4:45 PM

Oracle SQL: Return a character string for the first day of the current month (substitute any date field/value for SYSDATE if other months ar

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')