Please see my other Database Development articles.

Leveraging Format() for greater control over date values.

When displaying date values from a resultset, it is common to reformat them according to various specified business rules.

Using the t-sql Format along with specifying pattern provides an easy-to-use method, especially when abstracted into a reusable user-defined function.