select * from mytable where install_date > to_date('20050101','yyyymmdd');
来晚了 select * from mytable where to_char(install_date,'YYYYMMDD') > '20050101' select * from mytable where install_date > to_date('2005-01-01','yyyy-mm-dd'); 都是正解
select * from mytable where to_char(install_date,'YYYY-MM-DD') > '2005-01-01'
select * from mytable where month_between(install_date,to_date('2005-01-01','yyyy-mm-dd'))>0 接分,哈哈!
select * from mytable where to_char(install_date,'YYYYMMDD') > '20050101'
select * from mytable where install_date > to_date('2005-01-01','yyyy-mm-dd');
都是正解
select * from mytable where month_between(install_date,to_date('2005-01-01','yyyy-mm-dd'))>0
接分,哈哈!