Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Write a query to find the last day of the month

Posted By: Raimond Fischer     Category: Oracle     Views: 4197

Write a query to find the last day of the month.

Write a query to find the last day of the month

SELECT last_day(SYSDATE) FROM dual;

Output : 

LAST_DAY(
30-APR-97

SELECT last_day(DOB) FROM PSTUDENT;

Output : 

LAST_DAY(
31-MAR-83
31-OCT-82
30-JUN-83
30-SEP-82
29-FEB-80
31-MAR-80
31-JUL-83

  
Share: 

 
 
 

Didn't find what you were looking for? Find more on Write a query to find the last day of the month Or get search suggestion and latest updates.

Raimond Fischer
Raimond Fischer author of Write a query to find the last day of the month is from Frankfurt, Germany.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!