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