TO_CHAR(hire_date, 'dd month yyyy') AS hiredate1, TO_CHAR(hire_date, 'fmdd yyyy') AS hiredate2 -- remove 0 in days ...