MYSQL获取当前日期0点或其他日期0点

MySQL获取当前日期时间前几天0点 

1、获取当前日期的00点

select timestamp(date_add(curdate(), interval - 0 day));

+--------------------------------------------------+
| timestamp(date_add(curdate(), interval - 0 day)) |
+--------------------------------------------------+
| 2020-09-04 00:00:00                           |
+--------------------------------------------------+

 

2、获取当前时间的后一天（明天） 00点

select timestamp(date_add(curdate(), interval + 1 day));

+--------------------------------------------------+
| timestamp(date_add(curdate(), interval + 1 day)) |
+--------------------------------------------------+
| 2020-09-05 00:00:00                          |
+--------------------------------------------------+

 

3、获取当前日期时间的前一天（昨天）00点

select timestamp(date_add(curdate(), interval - 1 day));

+--------------------------------------------------+
| timestamp(date_add(curdate(), interval - 1 day)) |
+--------------------------------------------------+
| 2020-09-03 00:00:00                            |
+--------------------------------------------------+

 

4、获取本月1号的00点

select timestamp(date_add(curdate(), interval - day(curdate()) + 1 day));