How to get the last day of the current month?

I have explored all the available functions in the transformer stage, but could not find the exact function to get the last day of the current month. Can you please show me which function is available for this logic.

Questions by naveen.chinthala   answers by naveen.chinthala

Showing Answers 1 - 3 of 3 Answers

venueksh

  • Apr 8th, 2014
 

Oracle has a last_day() function.

SELECT LAST_DAY(to_date(07/04/2014,MM/DD/YYYY)) from dual;
SELECT LAST_DAY(SYSDATE) from dual;

  Was this answer useful?  Yes

venueksh

  • Apr 8th, 2014
 

Oracle has LAST_DAY function:

SELECT LAST_DAY(to_date(07/04/2014,MM/DD/YYYY)) from dual;
SELECT LAST_DAY(SYSDATE) from dual;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions