/* Display the dates */
SELECT TO_CHAR(my_date, 'MONTH DD, YYYY') FROM test003;

SELECT
  TO_CHAR(my_date, '"The " DDDth "day of the" YYYYth "year"') 
  FROM test003;