The Format Function can help you change how a date or decimal is displayed.
In this video I do a quick demonstration of the Format Function.
Video: SQL Server Format Function
How to use the SQL Format Function on a Date.
I use the Wide World Importers and the following scripts:
select OrderDate,Format(OrderDate,'MMM dd, yyyy') from [Sales].[Orders] where year(OrderDate) = 2016
Link to the Microsoft SQL Server Custom Date Formatters.
See the original SQL Format for Date video.
Leave a Question, Comment, or Reply. All are welcome!