below query will get the last day of the month select last

How to find last day of the month in sql query

Question Posted / vishwa

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

Please Help Members By Posting Answers For Below Questions

What do you mean by field in sql?

1121

What is sql profiling in oracle?

1128

Why having clause is used in sql?

1018

What is an exception in PL/SQL? What are the two types of exceptions?

1394

what are dynamic queries in t-sql? : Transact sql

1068

What is sqlcontext?

1142

how can we repair a mysql table? : Sql dba

1039

what is a composite key ? : Sql dba

1098

What is pl sql commands?

1094

What does varchar include?

991

Can you have more than one key in a database?

987

Does postgresql run on the cloud?

1218

What is materialized view in sql?

957

What is the difference between inner join and natural join?

1052

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1048