单选题查询出EMP表中1982年及以后入职的员工信息（）（注：字段hiredate为入职日期，数据类型为DATE型）A select * from emp where hiredate>='19820101';B select * from emp where hiredate>=to_char('19820101','YYYYMMDD');C select * from emp where to_date(hiredate,'YYYYMMDD')>='19820101';D select * from
题目
单选题
查询出EMP表中1982年及以后入职的员工信息（）（注：字段hiredate为入职日期，数据类型为DATE型）
A
select * from emp where hiredate>='19820101';
B
select * from emp where hiredate>=to_char('19820101','YYYYMMDD');
C
select * from emp where to_date(hiredate,'YYYYMMDD')>='19820101';
D
select * from emp where to_char(hiredate,'YYYYMMDD')>='19820101';