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

There are many date-time functions in mysql. Summarize some important functions, such as now (), curdate (), curtime (), date_add (), datediff (), date_format (). The usage and output results are described in detail below.

1 select now now () output 2018-10-1 12:00:00

2Query curdate ()

Select curdate () output 2018-10-1

3Gramming curtime ()

Select curtime () output 12:00:00

4, date_add ()

Select date_add ('2014-3-5 minute interval 3 week) 2014-04-2

5meme datediff ('2013-1-2')

6Ji data format ('2014-3-2% m% d% Y')

These are the common uses of date functions.

The article is from http://www.huthon.cn/.

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.