By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,649 Members | 1,808 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,649 IT Pros & Developers. It's quick & easy.

list the dates by week, month,year

P: 83
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
Dec 23 '06 #1
Share this Question
Share on Google+
1 Reply


ronverdonk
Expert 2.5K+
P: 4,258
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:
Dec 23 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.