Purpose
This function converts an expression into the specified data type if this is possible.
Syntax
convert::=
Usage Notes
- This function is an alias for
CAST. For more information, refer to CAST function.
Examples
Copy
SELECT CONVERT( CHAR(15), 'ABC' ) STRINGCAST;
SELECT CONVERT( DATE, '2006-01-01' ) DATECAST;