list the dates by week, month,year

[sang]

Hi
how to list the inserted dates by week,month and year.
That is how to select the dates by past one week.
similarly the month and year of the particular filed.

Thanks in Advance
Sang

[ronverdonk]

You can find your answer in the standard MySQL documentation.

The following shows you how to use the DATE_FORMAT() function that you need to use in your request. It also show examples of its usage:http://dev.mysql.com/doc/refman/4.1/...functions.html

Ronald :cool: