Produce a list of all employees and their date of hire (HireDate) in the format "ALLEN was hired on the "22nd of Feburary."
emp table
EmpNo Ename Job Mgr HireDate Sal Comm
7369 SMITH CLERK 7902 6/7/1980 800
7499 ALLEN SALESMAN 7698 2/2/1981 1600 300
7521 WARD SALESMAN 7698 2/6/1981 1250 500
7566 JONES MANAGER 7839 4/3/1981 2975
Months Table
Month MonthName
1 January
2 February
3 March
4 April
5 May
6 June
Ordinals Table
DayNumber DayOrdinal
1 1st
2 2nd
3 3rd
4 4th
5 5th
6 6th
7 7th