Show Me
 

Formatting Dates

Previous previous|next Next Page

Sheila wants to format her dates differently. She wants to produce a report that shows the employee's start date in the format of Month + Day + Year: the date 06-OCT-05 should appear as "October 6th, 2005."

For the birthdates in the DEPENDENTS table, she wants only the year to appear.

Launch Demonstration

Show Me and Try It: Use SQL Workshop to display the start dates of the employees in the format of Month + Day + Year