SELECT
*
FROM
user
WHERE
1 = 1
AND create_time > DATE_SUB( NOW( ), INTERVAL 3 DAY )
ORDER BY
create_time DESC
DATE_SUB( NOW( ), INTERVAL 3 DAY ) 当前时间减三天
DATE_ADD( NOW( ), INTERVAL 10 MINUTE )当前时间加十分钟
SELECT
*
FROM
user
WHERE
1 = 1
AND TO_DAYS( create_time ) = TO_DAYS( '2020-5-30' )
ORDER BY
create_time DESC
SELECT
*
FROM
user
WHERE
1 = 1
AND TO_DAYS( create_time) < TO_DAYS( '2020-5-30' )
AND TO_DAYS( create_time) > TO_DAYS( '2020-5-20' )
ORDER BY
create_time DESC
TO_DAYS( NOW( ) ) 就是从0年开始到现在的天数
XX的第XX
DAYOFWEEK(date)
DAYOFMONTH(date)
DAYOFYEAR(date)
WEEKOFYEAR(date)