How to find last day of the month in sql query

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the three pl sql block types?

719


How to load data with sql*loader?

745


What is a file delimiter?

742


What is the difference between delete, truncate and drop command?

749


What are the various restrictions imposed on view in terms of dml?

690






What is trigger and stored procedure in sql?

752


What is a column in a table?

770


What are the packages in pl sql?

742


Can a primary key be a foreign key?

750


can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

767


What is trigger in flip flop?

729


Explain the uses of database trigger.

845


what is innodb? : Sql dba

762


What is record in pl sql?

768


When do we use triggers?

800