使用UNIX日期操作 - OPERATION WITH UNIX DATE

OPERATION WITH UNIX DATE

本文关键字：操作日期 UNIX 使用 | 更新日期: 2023-09-27

我正在制作这样的SQL：

SELECT * FROM POST
WHERE date between :date1 and :date2

Date2永远是今天的日期PHP时间((；(UNIX格式(。现在我需要取日期2减去7天(1周(和日期2减去1个月。

(这将由用户在表单上选择(。

问题是，我无法让UNIX日期的操作正常工作。

$date2 = time();
$date1 = $_GET['fromDate'];
$query = "SELECT * FROM POST
          WHERE date between :date1 and :date2";

HTML表单

 select id=fromDate>
    <option value=<?php echo time()-604800>WEEK</option>
/select>

你尝试了什么？

$t=time();
# this would output current date
echo(date("D F d Y",$t));
# minus 7 days converted to seconds
$t -= 7*24*60*60;
# this would print the original $t minus 7 days
echo(date("D F d Y",$t));

$today = time();
$oneWeekAgo = time() - (60 * 60 * 24 * 7); // 60 seconds, 60 minutes, 24 hours, 7 days
$oneMonthAgo = time() - (60 * 60 * 24 * 30); // 60 seconds, 60 minutes, 24 hours, 30 days

或者更确切地说是$oneMonthAgo:

$date = date_create(); // get DateTime object of today
date_modify($date, "-1 month"); // 1 month ago
$oneMonthAgo = date_timestamp_get($date); // get unix time