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