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();