Hi I wanted to do a sql statement that pick entries between a certain date. I wanted to get all the records that were less than the current date and that were > currentdate - 7.
Is there a way to do this with oracle or do I have to do it on
the programmers side, I am using ASP for the language
select * from ennadm.menu, ennadm.cafetr where menu.cafetr_no = cafetr.cafetr_no and
menu.wk_begin_dt < SYSDATE and ????
Thanks for any help.