SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Finding Last friday and Last monday of current date

648631Jul 7 2008 — edited May 22 2013

Hi

Please help me to get the Last friday and Last monday of current date using an sql query.

If I am running query on 7th July 2008 ,it should give me Last friday as 07/04/2008 and Last monday as 07/07/2008

I need to compare it with another date filed

eg: Select * from employee where ReportedDate between [Last Friday] and [Last Monday]

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 19 2013

Added on Jul 7 2008

5 comments

27,850 views