mysql中的日期的使用总结

# 2021-06-08 10:32:13
select now();

# 2021-06-08 10:32:13
select current_date;

# 10:32:13
select current_time;

# 2021-12-12
select date_add('2020-12-21', interval 356 day);
# 2019-12-31
select date_add('2020-12-21', interval -356 day);
# 2021-12-21
select date_add('2020-12-21', interval 1 year);
# 2019-12-21
select date_add('2020-12-21', interval -1 year);
# 2021-01-21
select date_add('2020-12-21', interval 1 month);
# 2020-11-21
select date_add('2020-12-21', interval -1 month);
# 2020-12-28
select date_add('2020-12-21', interval 1 week);
# 2020-12-14
select date_add('2020-12-21', interval -1 week);


# 3
select datediff('2020-01-11', '2020-01-08');

# 2021-06-08
select date_format(now(), '%Y-%m-%d');