How to find last day of the month in sql query

Question Posted / shah.sonal2988

4 Answers
7031 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to find last day of the month in sql query..

Answer / vishwa

below query will get the last day of the month
select last_day(sysdate) from dual

Is This Answer Correct ?

14 Yes

0 No

How to find last day of the month in sql query..

Answer / ajit

select TO_CHAR( last_day(sysdate), 'day')
from dual

Is This Answer Correct ?

12 Yes

2 No

How to find last day of the month in sql query..

Answer / sujit pingale

select to_char(sysdate, 'day') from dual;

This will print output: tuesday i.e

select last_day(sysdate) from dual;

This will print output: 31-Aug-14

Is This Answer Correct ?

2 Yes

0 No

How to find last day of the month in sql query..

Answer / manoranjan sethy

Select LAST_DAY(Sysdate) From Dual;

Is This Answer Correct ?

2 Yes

0 No

Post New Answer