mysql between and 边界值及php月初月末的问题

之前一直认为between and 是不包括边界值的,今天测试了一下,发现其实是包含的

例子如下

关于php如何获取指定年月的第一天和最后一天,请看代码:

<?php$month = '12';$year = '2017';$firstDay = date('Y-m-d', mktime(0, 0, 0, $month, 1, $year));$endDay = date('Y-m-d', mktime(23, 59, 59, $month,date('t',strtotime($year.'-'.$month)),$year));var_dump($firstDay);var_dump($endDay);exit();

如果想获取本月第一天和下个月第一天 ,则需要在endDay那里面加一秒即可

<?php$month = '12';$year = '2017';$firstDay = date('Y-m-d', mktime(0, 0, 0, $month, 1, $year));$endDay = date('Y-m-d', mktime(23, 59, 59, $month,date('t',strtotime($year.'-'.$month)),$year)+1);var_dump($firstDay);var_dump($endDay);exit();