Skip to Main Content

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2011
Added on Mar 7 2011
14 comments
1,910 views