sql format date and time code example
Example 1: SQL Date Format
SELECT FORMAT(dbo.column, 'M/dd/yyyy')Example 2: sql server format datetime to short date
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )SELECT FORMAT(dbo.column, 'M/dd/yyyy')CONVERT ( data_type [ ( length ) ] , expression [ , style ] )