MySQL Date comparison

The interface used to make a date comparison, to return a period of time the data list.

The Data table field is "End_time", the time format is 2014-05-30 13:12:10, want to check the deadline for registration data.

Select field name from table where end_time > Current time;

The MySQL data table holds the Time field format Date,datetime,time,timestamp, and the comparison operator is consistent on both sides of the data format.

If we look at the number of news for 2014-05-30,

SELECT count (id) from tb_news WHERE end_time >= ' 2014-05-30 00:00:00 ' and Add_time <= ' 2014-05-30 23:59:59 '

The results obtained from this >= are expected, and the results obtained by <= are not what we want.

' 2014-05-30 ' is equivalent to ' 2014-05-30 00:00:00 ', and the record less than May 30 should be until May 29 23:59:59