Show Me Glossary
 

Formatting Dates

Previous previous|next Next Page

Sheila wants her dates formatted differently. She wants to produce a report that shows the employee's start dates in the format of Month, Day, Year so the 06-OCT-05 displays as October 6th, 2005.

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

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

Launch Demonstration

Show Me and Try It! - Use Query Builder to show the year that the dependents are born.