How to find last day of the month in sql query

Answer Posted / sujit pingale

select to_char(sysdate, 'day') from dual;

This will print output: tuesday i.e

select last_day(sysdate) from dual;

This will print output: 31-Aug-14

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get list of all tables from a database?

631


What is the best sql course?

534


Can we insert delete data in view?

548


what is a trigger in mysql? : Sql dba

607


What is a left join?

516






Does sqlite need a server?

543


What is plpgsql language?

534


Why do we use sql constraints? Which constraints we can use while creating database in sql?

551


Does truncate require commit?

547


what is 'mysqlimport'? : Sql dba

575


What is database migration?

521


Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

1688


How bulk collect improves performance?

574


Does pl/sql support create command?

578


What is an intersect?

657