--CONVERT Function The CONVERT function is used to convert an expression from one data type to another, but it also allows for formatting when converting to certain data types, like dates. -- Convert ...

CONVERT () is used when some additional formatting needs to happen, and can only be used with T-SQL. CAST () also preserves precision. For DECIMAL and NUMERIC types, Convert can cause rounding errors.