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