CONVERT

Purpose

This function converts an expression into the specified data type if this is possible.

Syntax

convert::=

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;