How to find last day of the month in sql query

Answer Posted / ajit

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

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is normalisation and its types?

552


Define sql delete statement.

572


Why we use joins in sql?

544


Which sorts rows in sql?

587


Explain the difference between triggers and constraints?

523






How do I run pl sql in sql developer?

630


what is sql server agent? : Sql dba

605


How do you write a complex sql query?

591


Can procedure in package be overloaded?

614


what is text? : Sql dba

564


How can you select unique records from a table?

524


What are the differences between in and exists clause?

571


What are commit, rollback, and savepoint?

573


How to look at the current sql*plus system settings?

606


What is the use of primary key?

539