Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

SELECT STR_TO_DATE(10 31 2003,GET_FORMAT(DATE,USA))

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>