Community

SQL Server – Formatted Date and Alias Name in ORDER BY Clause

(Pinal Dave) CONVERT function can be used to change the format of DATE to various formats like MM/dd/yyy, dd/MM/yyy, yyy/MM/dd, etc.