Oracle: Number of days in current month

Oracle Datetime: Exercise-6 with Solution

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

Sample Solution:

Oracle Code:

SELECT CAST (TO_CHAR (LAST_DAY (SYSDATE), 'dd') AS INT) number_of_days FROM DUAL; 

Output:

  	NUMBER_OF_DAYS
1	28

Go to:

• Oracle Datetime Exercises Home. ↩
• Oracle Exercises Home ↩

PREV : Write a Oracle SQL statement to get the first and last day of the current year.
NEXT : Write a Oracle SQL statement to get number of days between two given dates.

Improve this sample solution and post your code through Disqus.