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!

Selecting dates from friday till sunday???

user11961230Mar 7 2011 — edited Mar 7 2011

Hello folks,
Am trying to work on a query where there is a date selection in the where clause. i.e if sysdate is monday i have to get the data from friday until Sunday.

   and sh.change_date >=
               to_date('20110304 000000', 'YYYYMMDD HH24MISS')
           and sh.change_date <=
               to_date('20110306 235959', 'YYYYMMDD HH24MISS')

Now am hardcoding the dates that i want to see in the change_date. But Is there any way that every time when i run the query i dont have to change these date values??

Thanks a Bunch!

This post has been answered by Frank Kulash on Mar 7 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2011

Added on Mar 7 2011

14 comments

1,910 views