Q66 You need to calculate the number of days from 1st January 2019 until today

Posted on by Tran Anh

Q66 You need to calculate the number of days from 1st January 2019 until today.

Dates are stored in the default format of DD-MON-RR.

Which two queries give the required output? (Choose two.)

  • (A). SELECT TO_CHAR(SYSDATE,’DD-MON-YYYY’) – ’01-JAN-2019′ FROM DUAL;
  • (B). SELECT ROUND(SYSDATE – ’01-JAN-2019′) FROM DUAL;
  • (C). SELECT ROUND(SYSDATE – TO_DATE(’01/JANUARY/2019′)) FROM DUAL;
  • (D). SELECT TO_DATE(SYSDATE, ‘DD/MONTH/YYYY’) – ’01/JANUARY/2019′ FROM DUAL;
  • (E). SELECT SYSDATE – TO_DATE(’01-JANUARY-2019′) FROM DUAL;
Xem thêm:

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

0 0 đánh giá
Đánh giá bài viết
Theo dõi
Thông báo của
guest
0 Góp ý
Phản hồi nội tuyến
Xem tất cả bình luận