Otherwise, it will return the converted value. If the conversion fails, the function will return an error. In SQL Server (Transact-SQL), the CAST function converts an expression from one datatype to another datatype. We use the CAST function to convert numeric data into character or string data. The following are the syntax of CAST() function in MySQL: CAST(expression AS datatype) How do you use CAST function? It converts a value to the BINARY data type that contains the binary string. It converts a value to the UNSIGNED datatype that contains the unsigned 64-bit integer. It converts a value to SIGNED datatype that contains the signed 64-bit integer. It converts a value to the DECIMAL data type that contains a decimal string. It converts a value to the CHAR data type that contains the fixed-length string. It converts the value into TIME data type in the “HH:MM:SS” format. It converts the value into the DATETIME data type in the “YYYY-MM-DD HH:MM:SS” format. It supports the range of DATE in ‘’ to ‘’. It converts the value into DATE datatype in the “YYYY-MM-DD” format. The following are the datatypes to which this function works perfectly: Datatype The Cast() function provides a data type to a dynamic parameter (?) or a NULL value.
This function is similar to the CONVERT() function in MySQL. It is mostly used with WHERE, HAVING, and JOIN clauses. The CAST() function in MySQL is used to convert a value from one data type to another data type specified in the expression. If you are interested to learn about the MySQL Decimal
0 kommentar(er)
