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

how to install mysql? : Sql dba

1110

What is the difference between function and procedure in pl/sql?

1086

how can we submit a form without a submit button? : Sql dba

988

What is mdf ldf and ndf?

1002

Is postgresql a server?

1055

How do you optimize a query?

1003

How do you declare a variable in pl sql?

1029

What are all the ddl commands?

1184

How to set up sql*plus output format in oracle?

1038

How do rank () and dense_rank () differ?

1046

Can you do multiple joins in sql?

1053

What is the sql query to display the current date?

1044

what is schema? : Sql dba

1050

What does count (*) do in sql?

1016

what is self join and what is the requirement of self join? : Sql dba

1145