ROUND
TRUNC
EXTRACT
Truncates a date to the specified unit.
TRUNC(date [, fmt])
Enter values below to update the example in real time.
first_day_of_month
SELECT TRUNC(SYSDATE, 'MM') AS first_day_of_month FROM DUAL;
