fetching data from the db using date

[decon]

I want to fetch data from the db using date. My date format is yr/m/Dy. 1. i want to fetch data for a particular day. 2. data for a particular week 3. data for a particular month 4. and data for a particular year.

[egami]

I want to fetch Selma Hyak using a whistle and a fog horn. But I'm sure my results will be just like yours since you're expecting a hand-out.