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

What are three advantages to using sql?

1009

What is meant by temporal data?

962

What is embedded sql with example?

1037

Which is faster subquery or join?

1210

what are the features and advantages of object-oriented programming? : Sql dba

1003

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

971

Why do we need view in sql?

981

What are the datatypes available in pl/sql ?

1098

What is denormalization in a database?

1049

Is there a way to automate sql execution from the command-line, batch job or shell script?

968

What is scope and visibility in PL/SQL?

1195

how to get help information from the server? : Sql dba

939

How do you explain an index?

1280

How to get help at the sql prompt?

1110

Difference between table function and pipelined function?

1017