SELECT STR_TO_DATE('00/00/0000', '%m/%d/%Y'); : STR_TO_DATE : Date Time Functions MySQL TUTORIALS


MySQL TUTORIALS » Date Time Functions » STR_TO_DATE »

 

SELECT STR_TO_DATE('00/00/0000', '%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                            |
+---------------------------------------+
row in set (0.00 sec)

mysql>



Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

MySQL TUTORIALS

 Navioo Date Time Functions
» STR_TO_DATE