NowTime mysq中是 Varcher 类型
SELECT
*
FROM
USER
WHERE
NowTime >= CONCAT(
DATE_FORMAT(
DATE_SUB(now(),INTERVAL 1 DAY),
'%Y-%m-%d'
),
' 23:00:00'
)
AND NowTime <= CONCAT(
DATE_FORMAT(
DATE_SUB(now(),INTERVAL 0 DAY),
'%Y-%m-%d'
),
' 23:00:00'
)