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

Is progress software supports to ( pl/sql )?

711


What problem one might face while writing log information to a data-base table in pl/sql?

757


how to add a new column to an existing table in mysql? : Sql dba

771


Explain clause in sql?

748


how to show all tables with 'mysql'? : Sql dba

812






What is the difference between inner join and outer join?

705


Which is better varchar or nvarchar?

729


How to get each name only once from an employee table?

804


What is t sql used for?

729


What does (*) mean in sql?

711


Is there any restriction on the use of union in embedded sql?

875


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2175


What is the starting oracle error number? What is meant by forward declaration in functions?

736


what are rollup and cube in t-sql? : Transact sql

817


What is a memo field?

696