SQL Server Date Formats CAST and CONVERT

Date Formats CAST and CONVERT (Transact-SQL)
Converts an expression of one data type to another.
Topic link icon Transact-SQL Syntax Conventions
Syntax for CAST:
CAST ( expression AS data_type [ (length ) ])
Syntax for CONVERT:
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
SQL Server Date Formats

Default

SELECT CONVERT(VARCHAR(20), GETDATE(), 100)

Jan 1 2005 1:29PM 1

USA

SELECT [...]