oracle sql first day of previous month code example
Example 1: oracle sql first day of month
-- First day of month
SELECT TRUNC(sysdate, 'MONTH') from dual;
Example 2: oracle sql first day of year
-- Oracle: First day of year
SELECT TRUNC(sysdate, 'YEAR') from dual;