Which SQL statement returns a numeric value?

Which SQL statement returns a numeric value?

Which SQL statement returns a numeric value?

A.
SELECT ROUND(hire_date) FROM EMP;

B.
SELECT sysdate-hire_date FROM EMP;

C.
SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;

D.
SELECT TO_NUMBER(hire_date + 7) FROM EMP;

Explanation:



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Kevin

Kevin

B

DATE value subtracted from a DATE value will return numeric value.