how to get last monday of a month?

Question Posted / posamram

2 Answers
6413 Views
Multifonds, I also Faced
E-Mail Answers

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

Post New Answer

More Oracle General Interview Questions

What is an Integrity Constrains ?

3 Answers

what is shell?

2 Answers Microsoft,

Please explain drop constraint oracle?

0 Answers

what is the difference between UNION AND UNIONALL

4 Answers

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers

What is an oracle?

0 Answers

How to assign a tablespace to a users in oracle?

0 Answers

what is kernel?

2 Answers Microsoft,

How to export your own schema?

0 Answers

1) Does oracle have any table which contain all the exceptions and it's code internally?

0 Answers CTS,

How to use values from other tables in update statements using oracle?

0 Answers

what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?

1 Answers Arrow Electronics,

For more Oracle General Interview Questions Click Here