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

How to find last day of the month in sql query

Question Posted / ajit

Answer Posted / ajit

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

Is This Answer Correct ?

12 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How many types of sql are there?

1046

What is the default isolation level in sql server? : Transact sql

1088

What is pl sql block in dbms?

1055

Show the cursor attributes of pl/sql.

1101

What are stored procedures in mysql?

1074

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3110

Is sql an operating system?

1075

What are the types of triggers in sql?

1143

how is exception handling handled in mysql? : Sql dba

1130

What are the sql versions?

999

What is varray in pl sql?

1120

what are wild cards used in database for pattern matching ? : Sql dba

1205

How to check if a column is nullable before setting to nullable?

1186

What is a full join?

1043

what is timestamp in mysql? : Sql dba

1132