convert date time into date in sql 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 ] )