NOW

当前日期和时间

  1. mysql> SELECT NOW();
  2. +---------------------+
  3. | NOW()               |
  4. +---------------------+
  5. | 2020-02-13 11:02:02 |
  6. +---------------------+

CURDATE()

当前日期

  1. mysql> SELECT CURDATE();
  2. +------------+
  3. | CURDATE()  |
  4. +------------+
  5. | 2020-02-13 |
  6. +------------+

CURTIME()

当前时间

  1. mysql> SELECT CURTIME();
  2. +-----------+
  3. | CURTIME() |
  4. +-----------+
  5. | 11:02:42  |
  6. +-----------+

DATE_ADD()

日期变化

  1. -- 增加时间
  2. mysql> SELECT DATE_ADD('2020-2-13',INTERVAL 365 DAY);
  3. +----------------------------------------+
  4. | DATE_ADD('2020-2-13',INTERVAL 365 DAY) |
  5. +----------------------------------------+
  6. | 2021-02-12                             |
  7. +----------------------------------------+
  9. -- 减少时间
  10. mysql> SELECT DATE_ADD('2020-2-13',INTERVAL -365 DAY);
  11. +-----------------------------------------+
  12. | DATE_ADD('2020-2-13',INTERVAL -365 DAY) |
  13. +-----------------------------------------+
  14. | 2019-02-13                              |
  15. +-----------------------------------------+

DATEDIFF()

日期差值

  1. mysql> SELECT DATEDIFF("2020-2-13","2020-12-1");
  2. +-----------------------------------+
  3. | DATEDIFF("2020-2-13","2020-12-1") |
  4. +-----------------------------------+
  5. |                              -292 |
  6. +-----------------------------------+

DATE_FORMAT()

日期格式化

  1. mysql> SELECT DATE_FORMAT("2020-2-13","%Y,%m,%d");
  2. +-------------------------------------+
  3. | DATE_FORMAT("2020-2-13","%Y,%m,%d") |
  4. +-------------------------------------+
  5. | 2020,02,13                          |
  6. +-------------------------------------+