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, 1340🔥, 0💬
Popular Posts:
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...