SELECT CONVERT (data_type(length)),Date, DateFormatCode) code example Example: SQL Date Format SELECT FORMAT(dbo.column, 'M/dd/yyyy')