472,143 Members | 1,362 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,143 software developers and data experts.

list the dates by week, month,year

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
1 4748
4,258 Expert 4TB
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.

Similar topics

reply views Thread by Vincent Jones | last post: by
4 posts views Thread by Richard Hollenbeck | last post: by
26 posts views Thread by Frank | last post: by
2 posts views Thread by toedipper | last post: by
18 posts views Thread by PC Datasheet | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.