MySQL CAST Function: Examples

Back Home

Examples
Sample Database

#1

SELECT (1 + '1')/2;

#2

SELECT (1 + CAST('1' AS UNSIGNED))/2;

#3

SELECT CONCAT('MySQL CAST example #',CAST(2 AS CHAR));

#4

SELECT orderNumber,
       requiredDate
FROM orders
WHERE requiredDate BETWEEN '2003-01-01' AND '2003-01-31';

#5

SELECT orderNumber,
       requiredDate
FROM orders
WHERE requiredDate BETWEEN  CAST('2003-01-01' AS DATETIME)
                        AND CAST('2003-01-31' AS DATETIME);

#6

SELECT productName,
       CONCAT('Prices(',
               CAST(buyprice AS CHAR),
               ',',
                CAST(msrp AS CHAR),
      ')') prices
FROM products;

Table List