| 用途 | 时间处理 |
|---|---|
| 常用 | NOW() CURDATE() DATE_FORMAT() DATE_ADD() DATEDIFF() UNIX_TIMESTAMP() |
| 类型 | 返回 DATETIME / DATE / 数字 |
常用示例
常用示例
SELECT NOW(), CURDATE(), UNIX_TIMESTAMP();
SELECT DATE_FORMAT(created_at, '%Y-%m-%d %H:%i') AS t FROM orders LIMIT 1;
SELECT DATE_ADD(NOW(), INTERVAL 1 DAY) AS tomorrow;
SELECT DATEDIFF('2026-10-12', '2026-10-01') AS days;
SELECT created_at FROM orders WHERE created_at >= CURDATE() - INTERVAL 7 DAY;按日期过滤不要写成 WHERE DATE(created_at)='2026-10-12'，应写 created_at >= '2026-10-12' AND created_at < '2026-10-13' 才能用上索引。