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

How to find last day of the month in sql query

Question Posted / ajit

Answer Posted / ajit

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

Is This Answer Correct ?

12 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is constant in pl sql?

969

What is the use of function in sql?

1029

How many joins can you have in sql?

881

Is a secondary key the same as a foreign key?

955

what are the drivers in mysql? : Sql dba

985

What does where 1 1 mean in sql?

981

Does sql*plus also have a pl/sql engine?

1039

What is exit statement?

959

Does truncate free space?

948

What are triggers in sql?

974

How do I view tables in sql developer?

886

What is the purpose of a sql?

915

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1021

What is the difference between rename and alias?

1270

What are tables and fields?

975