查询出EMP表中1982年及以后入职的员工信息()(注:字段hiredate为入职日期,数据类型为DATE型)
- Aselect * from emp where hiredate>='19820101';
- Bselect * from emp where hiredate>=to_char('19820101','YYYYMMDD');
- Cselect * from emp where to_date(hiredate,'YYYYMMDD')>='19820101';
- Dselect * from emp where to_char(hiredate,'YYYYMMDD')>='19820101'