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

list the dates by week, month,year

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

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:

Ronald :cool:
Dec 23 '06 #2

Post your reply

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