how to get last monday of a month?

Question Posted / posamram

Answers were Sorted based on User's Feedback

how to get last monday of a month?..

Answer / posamram

select next_day(last_day(sysdate),'MON')-7 FROM DUAL;

Is This Answer Correct ?

13 Yes

2 No

how to get last monday of a month?..

Answer / shailesh

select NEXT_DAY(last_day(sysdate)-7,'THURSDAY') from dual;

Is This Answer Correct ?

6 Yes

4 No

More Oracle General Interview Questions

What is literal?

Explain overloading. Can functions be overloaded?

How will you write a query to get a 5th rank student from a table student_report?

What is rowid and rownum in oracle?

How to get the Installed Oracle Version Information ?

What are advantages fo Stored Procedures?

What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?

How to connect ms access to oracle servers?

What is Read-Only Transaction ?

Can you drop an index associated with a unique or primary key constraint?

How to view existing locks on the database?

what are views?

For more Oracle General Interview Questions Click Here