php - 处理日期

Question

这是我需要做的:

1. 我想在距当前日期 30 天后的日期时间 MySQL 字段中插入一个日期
2. 当我提取该特定记录时，我希望能够检查该日期是否已过(即过期日期)

Answer 1

INSERT INTO the_table
   (fields, the_date_field)
VALUES
   (?, DATE_ADD(NOW(), INTERVAL 30 DAY))

---

SELECT
   the_date_field < NOW() AS expired
FROM
   the_table

确认:

SELECT '2010-01-01' < NOW() AS expired;
+---------+
| expired |
+---------+
|       1 |
+---------+

SELECT '2012-01-01' < NOW() AS expired;
+---------+
| expired |
+---------+
|       0 |
+---------+