客户端运行,相同的写法可以在xml中运行,最直接的获取时间范围方法.
SELECT
*
FROM
(SELECT
DATE_FORMAT(CURDATE(), '%Y-%m-%d %00:%00:%00') startTime) temp
LEFT JOIN
(SELECT
DATE_FORMAT(CURDATE(), '%Y-%m-%d %23:%59:%59'
客户端运行,相同的写法可以在xml中运行,最直接的获取时间范围方法.
SELECT
*
FROM
(SELECT
DATE_FORMAT(CURDATE(), '%Y-%m-%d %00:%00:%00') startTime) temp
LEFT JOIN
(SELECT
DATE_FORMAT(CURDATE(), '%Y-%m-%d %23:%59:%59'