MySQL STR_TO_DATE Function - Features, Examples and Equivalents

STR_TO_DATE function converts a string in the specified format to DATETIME, DATE or TIME value.

Version: MySQL 5.6

Most common format specifiers in STR_TO_DATE function (full list...):

Related functionality for STR_TO_DATE in MySQL:

String to datetime conversion in other databases:

Oracle:

Format specifiers in MySQL and Oracle (full list...) are different:

SQL Server:

MySQL formats specifiers and SQL Server styles(full list...):

PostgreSQL:

Format specifiers in MySQL and PostgreSQL (full list...) are different:

Converting a string to datetime:

MySQL:

   SELECT STR_TO_DATE('17-09-2010','%d-%m-%Y');

Oracle:

Oracle TO_DATE and TO_TIMESTAMP functions can convert a string in the specified format. Note that the format specifiers are different (see mapping above).

   SELECT TO_DATE('17-09-2010','DD-MM-YYYY') FROM dual;

SQL Server:

SQL Server CONVERT function can convert a string to DATETIME, but instead of specifying format specifiers for date/time parts, you have to specify a style for the entire value (see mapping above):

   SELECT CONVERT(DATETIME, '17-09-2010', 105);

PostgreSQL:

PostgreSQL provides TO_DATE and TO_TIMESTAMP functions to convert a string in the specified format to DATE or TIMESTAMP.

The format specifiers are different from MySQL (see mapping above) but similar to Oracle:

   SELECT TO_DATE('17-09-2010','DD-MM-YYYY');

• MySQL Reference
• Date and Time Functions - MySQL 5.6 Reference Manual
• TO_DATE Function - Oracle 11g R2 SQL Language Reference
• TO_TIMESTAMP Function - Oracle 11g R2 SQL Language Reference
• CAST and CONVERT - SQL Server 2008 R2 Books Online
• Date/Time Functions and Operators - PostgreSQL 9.1 Documentation