PHP时间戳和日期的相互转换，根据具体日期筛选

date('Y-m-d',156468789);将时间戳转换为年月日形式
shrtotime("20200902");将具体日期转换成时间戳
date(‘Y-m-d’);获取当前日期

如果传过来是2020-09这样的，需要返回这一个月的数据的话

$date = '2020-09';
$time = strtotime(!empty($date) ? $date : 0);
$month_start = date('Y-m-d', $time);
$mdays = date('t', $time);
$month_end = date('Y-m-' . $mdays, $time);
1
2
3
4
5
查询当天:

$start = strtotime(date('Y-m-d'));;
$end = strtotime(date('Y-m-d H:i:s'));//
SELECT * FROM `table_name` WHERE `time` >= {$start} AND `time` <= {$end}
1
2
3
查询本周：

SELECT weekday( 'Y-m-d 00:00:00' )
SELECT weekday( ''Y-m-d H:i:s )
————————————————
查询本月：

$start = date('Y-m-01 00:00:00');
$end = date('Y-m-d H:i:s');
SELECT * FROM `table_name` WHERE `time` >= unix_timestamp('”.$start.”') AND `time` <= unix_timestamp('$end')

————————————————————————————————

查询本年：

$start = date('Y-01-01 00:00:00');
$end = date('Y-m-d H:i:s');
SELECT * FROM `table_name` WHERE `time` >= unix_timestamp( '$start' ) AND `time` <= unix_timestamp( '$end' )

 附加：

1. <?php
2.  
   echo "今天:".date("Y-m-d")."<br>";
3.  
   echo "昨天:".date("Y-m-d",strtotime("-1 day")), "<br>";
4.  
   echo "明天:".date("Y-m-d",strtotime("+1 day")). "<br>";
5.  
   echo "一周后:".date("Y-m-d",strtotime("+1 week")). "<br>";
6.  
   echo "一周零两天四小时两秒后:".date("Y-m-d G:H:s",strtotime("+1 week 2 days 4 hours 2 seconds")). "<br>";
7.  
   echo "下个星期四:".date("Y-m-d",strtotime("next Thursday")). "<br>";
8.  
   echo "上个周一:".date("Y-m-d",strtotime("last Monday"))."<br>";
9.  
   echo "一个月前:".date("Y-m-d",strtotime("last month"))."<br>";
10.  
    echo "一个月后:".date("Y-m-d",strtotime("+1 month"))."<br>";
11.  
    echo "十年后:".date("Y-m-d",strtotime("+10 year"))."<br>";
12.  
    ?>