tisumo

For ex, i want to know that today is tuesday or friday. Pls help me the query

i think that you can try this way:select count(dvd_id) from dvd_tablewhere released_date between (select next_day('31-Mar-2005','Tuesday') from dual) and (select next_day('31-Mar-2005','Tuesday')+21 from dual);