Q126 The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE

Posted on 29/10/2024 by Tran Anh

Q126 The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.

You want to display the date of the first Monday after the completion of six months since hiring. The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the week.

Which query can be used?

(A). SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(‘MONDAY’) FROM employees;
(B). SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), ‘MONDAY’) FROM employees;
(C). SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
(D). SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

Xem thêm:

Bài viết cùng chủ đề:

0 0 đánh giá

Đánh giá bài viết

Theo dõi

0 Góp ý

Phản hồi nội tuyến

Xem tất cả bình luận