查询出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';
正确答案:D
答案解析:有
微信扫一扫手机做题