![]() ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |