TO_CHAR(hire_date, 'dd month yyyy') AS hiredate1, TO_CHAR(hire_date, 'fmdd yyyy') AS hiredate2 -- remove 0 in days ...
insert into employee (employeeid , name , surname , salary , dateofbirth , department , email , phone,managerId) values ( 1,'james','smith',1000,'01 May 1983', 'HR ...