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

This article is to share with you the content of a case about the mysql query period. 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.

Mysql query time period method: 1, the traditional way, that is, specify the start time and end time; 2, UNIX timestamp, each time corresponds to a unique UNIX timestamp, the function is [UNIX_TIMESTAMP (datetime)].

The method of querying time period in mysql:

Method 1: the traditional way, that is, specify the start time and end time, use "between" or "" to establish conditions, such as query the number of data items from March 1, 2010 to March 2, 2010, you can use the

Select count (*) from sometable where datetimecolumn > = '2010-03-01 00 and datetimecolumn=UNIX_TIMESTAMP (' 2010-03-01 00 and datetimecolumn=UNIX_TIMESTAMP) and datetimecolumn

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.