get 1st date of month in Oracle sql code example Example: oracle sql first day of month -- First day of month SELECT TRUNC(sysdate, 'MONTH') from dual;