Tutorial Gateway

MySQL STR_TO_DATE Function

by

MySQL STR_TO_DATE function is a Date Function, which acts as an inverse of DATE_FORMAT function. This function takes string as an input, and converts string to Date or DateTime or Time values based on the format given by the user.

In this article, we will show you, How to use this MySQL STR_TO_DATE function to convert the string to Date or date and time expression with an example.

MySQL STR_TO_DATE Syntax

The basic syntax of the STR_TO_DATE() Function in MySQL is as shown below:

STR_TO_DATE(string_expression, format);

MySQL STR_TO_DATE Example

Here, We used the STR_TO_DATE function to convert the different string formats to Date using %d %m and %Y formatters.

SELECT STR_TO_DATE('31 12 2019', '%d %m %Y');

SELECT STR_TO_DATE('31,12,2019', '%d,%m,%Y');

SELECT STR_TO_DATE('12,2019,31', '%m,%Y,%d');

OUTPUT

MySQL STR_TO_DATE Function 1

This is an another example of this function.

SELECT STR_TO_DATE('12 Jan, 2019', '%d %b, %Y');

SELECT STR_TO_DATE('2nd Jan, 2019', '%D %b, %Y');

SELECT STR_TO_DATE('2nd January, 2019', '%D %M, %Y');

OUTPUT

MySQL STR_TO_DATE Function 2

Thank You for Visiting Our Blog