Shulou(Shulou.com)06/01 Report--

This article is about mysql's method of converting dates to string types. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

In mysql, you can convert the date type to a string through the statement "select date_format ('2008-08-08-08-08-08-08-08-08-08-08-08-08-08-01-08-08-08-08-08-08-01-08-08-08 / 08-08 / 08 / 08 / 08 / 08 / 08 / 08 / 08), which converts the date type into a string,'% Y% m% d% H% I% s').

MySQL date-time type conversion string

Date / time type converted to string type

Date_format (date,format): date transfer string

Select date_format ('2008-08-08 / 08 / 08 / 08 / 08 / 08 / 08 / 08 / 08 / 08 / 08 / 08 / 08 / 08 / 08 / 08 / 08 / 08 / 08 / 08)

Time_format (time,format): time transfer string

Select time_format ('08 select time_format,'% H% I% s')

Thank you for reading! So much for mysql's method of converting dates to string types. I hope the above can be of some help to you so that you can learn more. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.