[abq47]

I need to list all employees and their date of hire (HireDate) in the format "ALLEN was hired on the 20TH of FEBRUARY."

Emp Table

EmpNo Ename Job Mgr HireDate
7369 SMITH CLERK 7902 12/17/1980
7499 ALLEN SALESMAN 7698 2/20/1981
7521 WARD SALESMAN 7698 2/22/1981
7566 JONES MANAGER 7839 4/2/1981

Month table

Month MonthName
1 January
2 February
3 March
4 April


ordinals table
DayNumber DayOrdinal
1 1st
2 2nd
3 3rd
4 4th

[mab]

Thread moved to database.

What exactly do you need help with?

[abq47]

I have no idea on how to relate the months table to the ordinal table to parse the hiredate to a string i.e. 11/20/08 into 11th November 2008