Mysql simple date month query statement

This article introduces two SQL date operation statements, one is to query the data between two dates, and the other is to find the data of the current month. The Code is as follows.

This article introduces two SQL date operation statements, one is to query the data between two dates, and the other is to find the data of the current month. The Code is as follows.

Query data between two dates:

The Code is as follows:
SELECT * FROM 'cangku 'WHERE (shijian> = '2014-1-13') and (shijian <= '2014-1-20 ′))

Query data for the current month:

The Code is as follows:
* From tables where month (Date) = month (now ())