Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. SELECT STR_TO_DATE(00000000, %m%d%Y)
mysql>
mysql> SELECT STR_TO_DATE('00/00/0000', '%m/%d/%Y');
+---------------------------------------+
| STR_TO_DATE('00/00/0000', '%m/%d/%Y') |
+---------------------------------------+
| 0000-00-00                            |
+---------------------------------------+
1 row in set (0.00 sec)
mysql>