SQL-datadiff()应用

一、作用：返回两个日期之间的时间间隔

二、语法：datediff(datepart,startdate,enddate)

是后面日期减去前面的日期(enddate-startdate)

1、datepart，规定应在日期的哪一部分计算差额

日期 缩写

year yy/yyyy

quarter qq/q

Month mm/m

day dd/d

Hour hh/h

minute mi,n

second ss,s

示例

leetcode 1141题：查询近30天活跃用户数

# Write your MySQL query statement below
select activity_date as day,
count(distinct user_id) as active_users
from activity
where datediff("2019-07-27",activity_date)>=0
and datediff("2019-07-27",activity_date)<30
group by activity_date