单选题

查询出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';

正确答案

来源:www.examk.com

答案解析