SELECT CAST ( '1' AS BIT ) As BitTrue, CAST ( '0' AS BIT ) As BitFalseĬAST( expression AS ) converts the expression to one of three data types that map to %Library.Binary Opens in a new tab (SQLType data type BINARY).īINARY VARYING and VARBINARY have a default length of 30. This statement returns Name (a character string), Age (a numeric value) and DOB (a date value) as VARCHAR data types. VARCHAR and NVARCHAR are equivalent data types and have a default length of 30 characters.
These data types all map to %Library.String Opens in a new tab.ĬHAR, CHARACTER, and NCHAR are equivalent data types and have a default length of 1 character. Character StringsĬAST( expression AS ) converts a numeric or string expression to a character string data type.
If you specify a CAST with an unsupported data type, InterSystems IRIS® issues an SQLCODE -376. InterSystems SQL provides CONVERT implementations that are compatible with MS SQL Server and ODBC. Whereas CAST is implemented using the ANSI SQL-92 standard, CONVERT implementations are database-specific.
For example, CONVERT supports the conversion of stream data and enables formatting of date and time values.ĬAST provides more database compatibility than CONVERT. For a list of the data types supported by InterSystems SQL, see Data Types.ĬAST is similar to CONVERT, with these differences:ĬONVERT is more flexible than CAST. The SQL CAST function converts the data type of an expression to the specified data type.
0 kommentar(er)
