SQL Server convert code example
Example 1: sql server convert string to date
Cast( '2011-07-07' as date ) as convertedDate
Example 2: SQL Date Format
SELECT FORMAT(dbo.column, 'M/dd/yyyy')
Example 3: sql convert
-- CAST Syntax:
CAST ( expression AS data_type [ ( length ) ] )
-- CONVERT Syntax:
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )