STR_TO_DATE() function in MySQL

STR_TO_DATE() : This function in MySQL helps to convert string values to date or time or DateTime values. The function will return zero (0000-00-00) if an empty string is passed as an argument. Syntax :

STR_TO_DATE(string, format)

Parameters :

• string -The string which will be converted to DateTime.
• format -The format in which it will be converted.

Return :

• The function will return the DateTime value of the given string in a specified format.
• The function will return zero (0000-00-00) if an empty string is passed as an argument.

Example-1 : Converting '21, 7, 2023' to date value having '%d, %m, %Y' format using STR_TO_DATE() function.

SELECT STR_TO_DATE('21, 07, 2023', '%d, %m, %Y') 
As New_form;

Output :

New_form
2023-07-21

Example-2 : Converting '1900' to date value having '%Y' format using STR_TO_DATE() function.

SELECT STR_TO_DATE('1900', '%Y') 
As New_form;

Output :

New_form
1900-00-00

Example-3 : Converting '111111' to time value having '%h%i%s' format using STR_TO_DATE() function

SELECT STR_TO_DATE('111111', '%h%i%s') 
As New_form;

Output :

New_form
11:11:11

Example-4 : Passing an empty string as an argument of STR_TO_DATE() function.

SELECT STR_TO_DATE('', '%h') 
As New_form;

Output :

New_form
00:00:00

Example-5 : Converting '20100212 103545' to DateTime value having '%Y%m%d %h%i%s' format using STR_TO_DATE() function.

SELECT STR_TO_DATE('20100212 103545', '%Y%m%d %h%i%s') 
As New_form;

Output :

New_form
2010-02-12 10:35:45