Skip to Main Content
Forums

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!

How to get current weeks particular date of a day

888025Mar 10 2014 — edited Mar 10 2014

Hi,

  for example I need current week 'Tuesday' Date
                                                       
if i run
select next_day ( trunc (sysdate) , 'Tuesday'  ) from dual I am getting 11-MAR-14

If i run the same tomorrow i am getting as 18, but I need it as 11th when ever i run this week because current week tuesday is 11-mar-2014

select next_day ( trunc (sysdate+1) , 'Tuesday'  ) from dual

Appreciate your help..

thanks..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2014
Added on Mar 10 2014
7 comments
830 views