Write a Oracle SQL statement to get the number of days in current month

hamza

Save to bookmark

2022-05-18

152

Write a Oracle SQL statement to get the number of days in 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 CAST (TO_CHAR (LAST_DAY (SYSDATE), 'dd') AS INT) number_of_days FROM DUAL;

Output:

  	NUMBER_OF_DAYS
1	28

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

total answers (1)