Function MySQL

  1. Home
  2. MySQL
  3. Function
  4. Converted a numeric value to the DATE conversion type
mysql>
mysql>
mysql> SELECT CAST(20041031 AS DATE);
+------------------------+
| CAST(20041031 AS DATE) |
+------------------------+
| 2004-10-31             |
+------------------------+
1 row in set (0.00 sec)