Question

select ename,hiredate, round(months_between(sysdate,hiredate)) months from emp

30.

(单选题)下列用于计算员工入职的月份，月份用四舍五入后的整数表示， 正确的SQL语句是（ ）。

A.

select ename,hiredate, trunc(between_months(sysdate,hiredate)) months from emp
.

B.

select ename,hiredate, trunc(months_between(sysdate,hiredate)) months from emp
.

C.

select ename,hiredate, round(months_between(sysdate,hiredate)) months from emp
.

D.

select ename,hiredate, round(between_months(sysdate,hiredate)) months from emp

Answer 1

哦哦哦