Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

STR_TO_DATE

Syntax

STR_TO_DATE (str, format)

Arguments

str: a valid date, datetime, or time, formatted according to the specified format string
format: a string containing format symbols

See DATE_FORMAT for a description of format symbols.

Return Type

String

Examples

SQL

SELECT STR_TO_DATE('March 3rd, 2015', '%M %D, %Y');

+---------------------------------------------+
| STR_TO_DATE('March 3rd, 2015', '%M %D, %Y') |
+---------------------------------------------+
| 2015-03-03                                  |
+---------------------------------------------+

SQL

SELECT STR_TO_DATE('2015-03-03 11:37:07', '%Y-%m-%d %h:%i:%s');

+---------------------------------------------------------+
| STR_TO_DATE('2015-03-03 11:37:07', '%Y-%m-%d %h:%i:%s') |
+---------------------------------------------------------+
| 2015-03-03 11:37:07                                     |
+---------------------------------------------------------+

SQL

SELECT STR_TO_DATE('Tuesday, the 3rd day of March in that remarkable year 2015', '%W, the %D day of %M in that remarkable year %Y') AS florid;

+------------+
| florid     |
+------------+
| 2015-03-03 |
+------------+