sql help

[prodadmin]

Guys,

I would like to know how to retrieve data between from a monday to sunday

For example from the 17th to 23 feb2003.I don't want to hard-code the dates but i want to tell the query to pull the data from monday to sunday of previous week


thanks for help in advance.

[stecal]

Use the day of week component (0-6, 1-7).

[mkumarnk]

OR between next_day(sysdate,'MON')-7 and next_day(sysdate,'MON')-1

[pras]

Hi,

I think it should be..

between next_day(sysdate,'SUN')-7 and next_day(sysdate,'MON')-1

CAUSE UR USING BETWEEN..

Thanks
pras

[prodadmin]

Thx for the help guys !!!!!