Collections:
Converting Character Strings to Dates in MySQL
How To Convert Character Strings to Dates in MySQL?
✍: FYIcenter.com
If you have a character string that represents a date, and you want to convert it into a date value, you can use the STR_TO_DATE(string, format) function. STR_TO_DATE() shares the same formatting codes with DATE_FORMAT() function. The tutorial exercise below shows you some good examples:
SELECT STR_TO_DATE('Friday, January 31, 1997', '%W, %M %e, %Y') FROM DUAL; 1997-01-31 SELECT STR_TO_DATE('Friday, January 31, 1997, 09:26:50 AM', '%W, %M %e, %Y, %h:%i:%s %p') FROM DUAL; 1997-01-31 09:26:50 SELECT STR_TO_DATE('31-Jan-1997 09:26:50.000123', '%d-%b-%Y %H:%i:%s.%f') FROM DUAL; 1997-01-31 09:26:50.000123
⇒ Date and Time Intervals in MySQL
⇐ Converting Dates to Character Strings in MySQL
2017-12-26, 1434🔥, 0💬
Popular Posts:
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...