PHP日期和MYSQL日期

+++++++++++++ 今天、昨天、明天 、上一周、下一周 +++++++++++++++

<?php
date_default_timezone_set('PRC'); //默认时区
echo "今天:",date("Y-m-d",time()),"<br>";
echo "昨天:",date("Y-m-d",strtotime("-1 day")), "<br>";
echo "明天:",date("Y-m-d",strtotime("+1 day")), "<br>";
echo "一周后:",date("Y-m-d",strtotime("+1 week")), "<br>";
echo "一周零两天四小时两秒后:",date("Y-m-d G:H:s",strtotime("+1 week 2 days 4 hours 2 seconds")), "<br>";
echo "下个星期四:",date("Y-m-d",strtotime("next Thursday")), "<br>";
echo "上个周一:".date("Y-m-d",strtotime("last Monday"))."<br>";
echo "一个月前:".date("Y-m-d",strtotime("last month"))."<br>";
echo "一个月后:".date("Y-m-d",strtotime("+1 month"))."<br>";
echo "十年后:".date("Y-m-d",strtotime("+10 year"))."<br>";
?>

//指定日期加(+) n 或减(-) n 天 day 、周 week 、月 month、年 year、时 hour、分 minute、秒 second
$cur_date = "2023-03-02";
$n = 3;
$new_date = date('Y-m-d',strtotime("$cur_date+{$n} day"));
$new_date = date("Y-m-d",strtotime("+{$n} day",strtotime($cur_date)));

$new_date = date('Y-m-d H:i:s',strtotime("+1 day +1 hour +1 minute");

mysql 语句当前日期减6个月
date_sub(NOW(), interval 6 month)
mysql 语句当前日期加6个月
date_add(NOW(), interval 6 month)