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!