上一周
SELECT
DATE_FORMAT(
date_add(
now(),
INTERVAL - (8 + weekday(now())) DAY),
'%Y-%m-%d 00:00:00'
),
DATE_FORMAT(
date_add(
now(),
INTERVAL - (1 + weekday(now())) DAY),
'%Y-%m-%d 23:59:59'
)
前几天
a.updateTime BETWEEN DATE_FORMAT(
date_add(
now(),
INTERVAL -? DAY),
'%Y-%m-%d 00:00:00'
)AND
DATE_FORMAT(
date_add(
now(),
INTERVAL - 1 DAY),
'%Y-%m-%d 23:59:59'
)
----------------------------------
LEFT JOIN (
SELECT
@timeStart := date_format(date_add(
now(),
INTERVAL -3 DAY), '%Y-%m-%d 00:00:00') ,@timeEnd := date_format(date_add(
now(),
INTERVAL -1 DAY), '%Y-%m-%d 23:59:59')
) c ON 1 = 1
当天
LEFT JOIN (
SELECT
@timeStart := date_format(NOW(), '%Y-%m-%d 00:00:00') ,@timeEnd := date_format(NOW(), '%Y-%m-%d 23:59:59')
) c ON 1 = 1
今天到当前
LEFT JOIN (
SELECT
@timeStart := date_format(NOW(), '%Y-%m-%d 00:00:00') ,@timeEnd := date_format(NOW(), '%Y-%m-%d %H:%i:%s')
) c ON 1 = 1
网友评论