SELECT STR_TO_DATE('10.31.2003',GET_FORMAT(DATE,'USA')); : GET_FORMAT « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. GET_FORMAT
mysql>
mysql> SELECT STR_TO_DATE('10.31.2003',GET_FORMAT(DATE,'USA'));
+--------------------------------------------------+
| STR_TO_DATE('10.31.2003',GET_FORMAT(DATE,'USA')) |
+--------------------------------------------------+
| 2003-10-31                                       |
+--------------------------------------------------+
1 row in set (0.02 sec)

mysql>








14.20.GET_FORMAT
14.20.1.GET_FORMAT(DATE|TIME|DATETIME, 'EUR'|'USA'|'JIS'|'ISO'|'INTERNAL')
14.20.2.GET_FORMAT(DATE,'USA')
14.20.3.GET_FORMAT(DATE,'JIS')
14.20.4.GET_FORMAT(DATE,'ISO')
14.20.5.GET_FORMAT(DATE,'EUR')
14.20.6.GET_FORMAT(DATE,'INTERNAL')
14.20.7.GET_FORMAT(DATETIME,'USA')
14.20.8.GET_FORMAT(DATETIME,'JIS')
14.20.9.GET_FORMAT(DATETIME,'ISO')
14.20.10.GET_FORMAT(DATETIME,'EUR')
14.20.11.GET_FORMAT(DATETIME,'INTERNAL')
14.20.12.GET_FORMAT(TIME,'USA')
14.20.13.GET_FORMAT(TIME,'JIS')
14.20.14.GET_FORMAT(TIME,'ISO')
14.20.15.GET_FORMAT(TIME,'EUR')
14.20.16.GET_FORMAT(TIME,'INTERNAL')
14.20.17.SELECT DATE_FORMAT('2003-10-03',GET_FORMAT(DATE,'EUR'));
14.20.18.SELECT STR_TO_DATE('10.31.2003',GET_FORMAT(DATE,'USA'));