1,筛选当天记录
select
*
from
table_1
where
date_col>=
date
(now())
and
date_col<DATE_ADD(
date
(now()),INTERVAL 1
DAY
)
1,筛选当天记录
select
*
from
table_1
where
date_col>=
date
(now())
and
date_col<DATE_ADD(
date
(now()),INTERVAL 1
DAY
)