Write a Oracle SQL statement to determine how many days are left in the current month

hamza

Save to bookmark

2022-05-18

151

Write a Oracle SQL statement to determine how many days are left in the current month.

Oracle,

hamza

2022-05-18

need an explanation for this answer? contact us directly to get an explanation for this answer

Oracle Code:

SELECT SYSDATE,
       LAST_DAY(SYSDATE) "Last",
       LAST_DAY(SYSDATE) - SYSDATE "Days Left"
  FROM DUAL;

Output:

  	SYSDATE					Last					Days Left
1	2/24/2021 12:38:14 PM	2/28/2021 12:38:14 PM	4

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)