CONVERT
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
SELECT CONVERT( CHAR(15), 'ABC' ) STRINGCAST;
SELECT CONVERT( DATE, '2006-01-01' ) DATECAST;