I’m always amazed how much traffic some of my articles on the Oracle date datatype get, but dealing with dates in SQL can be as daunting for beginners as it is tedious for the experts.
Well, here’s another resource to help you sort out those pesky dates. This one focuses on the to_char function and how it can be used to get dates to output in the format you want.
This article from Don Burleson offers a couple handy examples of the to_char function, but more importantly has a table listing the options for output of the date format.
For more reading on the Oracle date format check out my other Oracle stories.