Parse date in MySQL

by

You may want to use the STR_TO_DATE() function. It’s the inverse of the DATE_FORMAT() function.

STR_TO_DATE(str,format)

This is the inverse of the DATE_FORMAT() function. It takes a string str and a format string format. STR_TO_DATE() returns a DATETIME value if the format string contains both date and time parts, or a DATE or TIME value if the string contains only date or time parts. If the date, time, or datetime value extracted from str is illegal, STR_TO_DATE() returns NULL and produces a warning.

Example:

SELECT STR_TO_DATE('15-Dec-09', '%d-%b-%y') AS date;
+------------+
| date       |
+------------+
| 2009-12-15 |
+------------+
1 row in set (0.00 sec)

More Related Contents:

  1. Convert timestamp to date in MySQL query
  2. mysql date comparison with date_format
  3. How do you use MYSQL in ColdFusion? [closed]
  4. Using LIMIT within GROUP BY to get N results per group?
  5. How do I do a bulk insert in mySQL using node.js
  6. Reorder / reset auto increment primary key
  7. Required to join 2 tables with their FKs in a 3rd table
  8. Quick easy way to migrate SQLite3 to MySQL? [closed]
  9. Setting the MySQL root user password on OS X
  10. How to change the CHARACTER SET (and COLLATION) throughout a database?
  11. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  12. Convert partially non-numeric text into number in MySQL query
  13. MYSQL ORDER BY CASE Issue
  14. Can’t use a MySQL connection for entity framework 6
  15. MySQL difference between two rows of a SELECT Statement
  16. MySQL JOIN with LIMIT 1 on joined table
  17. MySQL Select last 7 days
  18. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  19. MySQL view performance
  20. Does MySQL Regexp support Unicode matching
  21. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  22. How to retrieve JSON data from MySQL?
  23. Is incrementing a field in MySQL atomic?
  24. Delete from one table with join
  25. MySQL column type “TIMESTAMP” implicitly includes “NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”
  26. MySQL: Compare BETWEEN time
  27. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  28. The web application [] appears to have started a thread named [Abandoned connection cleanup thread] com.mysql.jdbc.AbandonedConnectionCleanupThread
  29. Execute INSERT if table is empty?
  30. INSERT INTO fails with node-mysql

Leave a Comment