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

is database gud carrier option??

What is an oracle table?

How to assign a table row to a record variable?

What is the difference between hot backup and cold backup in oracle?

Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table

What are the varoius components of physical database structure of oracle database?

What are the different pseudo commands? Explain in general?

Does oracle partitioning improve performance?

What is a Tablespace?

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

How to use attributes of the implicit cursor in oracle?

What privilege is needed for a user to delete rows from tables in another schema?

For more Oracle General Interview Questions Click Here