select
*
from
club_member_info
where
handle_time>=to_date('2006-01-10 00:00:00','yyyy-mm-dd hh24:mi:ss')
and
handle_time<=to_date('2006-01-10 23:59:59','yyyy-mm-dd hh24:mi:ss');
*
from
club_member_info
where
handle_time>=to_date('2006-01-10 00:00:00','yyyy-mm-dd hh24:mi:ss')
and
handle_time<=to_date('2006-01-10 23:59:59','yyyy-mm-dd hh24:mi:ss');
格式不对吧
select * from club_member_info where handle_time=to_date('20060110','yyyy-MM-dd');
select * from club_member_info where handle_time=to_date('20060110','yyyy-MM-dd');