select * from emp where hiredate > '1982-1-1'; -- mysql
select * from emp where hiredate > to_date('1982-1-1', 'yyyy-mm-dd'); -- oracle
changrunwei 2018-07-15 05:45 原文
select * from emp where hiredate > '1982-1-1'; -- mysql
select * from emp where hiredate > to_date('1982-1-1', 'yyyy-mm-dd'); -- oracle