w3resource

Oracle: Get the last day of the current month

Oracle Datetime: Exercise-2 with Solution

Write a Oracle SQL statement to get the last date of the current month.

Sample Solution:

Oracle Code:

SELECT TRUNC (LAST_DAY (SYSDATE)) "Last day of current month" FROM DUAL;

Output:

  	Last day of current month
1	2/28/2021 12:00:00 AM

Improve this sample solution and post your code through Disqus.

Previous: Write a Oracle SQL statement to get the first date of the current month.
Next: Write a Oracle SQL statement to get the current date in the specified session time zone.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.