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

Editor to share with you the way mysql var to date, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to understand it!

The method of converting mysql var to date: first use the str_to_date function to change its varchar type to date type, and then sort it from smallest to largest.

The table is as follows:

First use the str_to_date function to change its varchar type to a date type, and then sort from small to large

Syntax: select str_to_date (class_time,'%Y%m%d% HRV% iRO% s') a from an order by a desc

Next, take a look at the date format conversion date type of varchar type in oracle.

Date format conversion of varchar type in oracle date type

SELECT to_char (to_date (m. Makeshift datetime) Mmurdd hh34:mi:ss')

'yyyyMMdd') FROM my_task m

M.ma_datetime is the date format of varchar2 type. Convert date type first.

(hours and seconds must be added, otherwise an ora-01830 error will be reported)

And then convert to the varchar type at will

The above is all the content of the way of mysql var to date, thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.