[MSSQL] Format Date

To convert date to string date formatted with mm/dd/yyyy.

SELECT CONVERT(VARCHAR(10), GETDATE(), 102) AS [MM/DD/YYYY]

To convert date to string date formatted with dd/mm/yyyy.


select convert(varchar,getdate(),103)