CONVERT datetime to string

Use the CONVERT function to convert a date or datetime to a string. The first parameter is the date or datetime type. The second parameter is the string expression. The third parameter is the date_style. Date expressions are not supported.

Syntax

CONVERT(datetime_expression,string_expression, date_style)