时间间隔

2019-08-28  本文已影响0人  路人爱早茶

上一周

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

上一篇 下一篇

猜你喜欢

热点阅读