Community SQL Server – Formatted Date and Alias Name in ORDER BY Clause by SSWUG Research (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. Register to Read