select * from emp where hiredate > '1982-1-1'; -- mysql
select * from emp where hiredate > to_date('1982-1-1', 'yyyy-mm-dd'); -- oracle
转载于:https://www.cnblogs.com/Mike_Chang/p/9311750.html
select * from emp where hiredate > '1982-1-1'; -- mysql
select * from emp where hiredate > to_date('1982-1-1', 'yyyy-mm-dd'); -- oracle
转载于:https://www.cnblogs.com/Mike_Chang/p/9311750.html