Essential Books

STR TO DATE - Convert string to date

suggest change

With a column of one of the string types, named my_date_field with a value such as [the string] 07/25/2016, the following statement demonstrates the use of the STR_TO_DATE function: 

SELECT STR_TO_DATE(my_date_field, '%m/%d/%Y') FROM my_table;

You could use this function as part of WHERE clause as well.

Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

String operations:
* String operations
* Find element in comma separated list
* STR TO DATE - Convert string to date
* LOWER LCASE
* REPLACE
* SUBSTRING
* UPPER, UCASE
* LENGTH
* CHAR LENGTH
* HEX
Table Of Contents