oracle查询时间字段
select count(t.id) from U_User_Info t where
t.add_date >=to_date('2015/4/10 00:00:00', 'yyyy/mm/dd HH24:mi:ss') and
t.add_date <=to_date('2015/4/10 23:59:59', 'yyyy/mm/dd HH24:mi:ss')
oracle查询时间字段
select count(t.id) from U_User_Info t where
t.add_date >=to_date('2015/4/10 00:00:00', 'yyyy/mm/dd HH24:mi:ss') and
t.add_date <=to_date('2015/4/10 23:59:59', 'yyyy/mm/dd HH24:mi:ss')