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

which language is used to develop the oracle........?

How many categories of data types?

What is the difference between implicit index and explicit index?

What happens if the update subquery returns multiple rows?

What is Undo Management Advisor in Oracle?

What is the oracle implicit cursor?

How to connect to a local oracle 10g xe server?

What is oracle instant client?

How to define a variable to match a table column data type?

How different is ms access and oracle?

How to rename a tablespace in oracle?

Youre getting high busy buffer waits - how can you find whats causing it?

For more Oracle General Interview Questions Click Here