How to Group Data Month when Using Datetime Column MySQL >

Asked By david allen 10 points N/A Posted on - 06/01/2011

I'm running MySQL and I have a table titled Datetime in YYYY-MM-DD HH:MM:SS format. How can I group the Data Month on Datetime Column?

• Status: Open
• Question Views: 642
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Software Others

Answered By andre ford 0 points N/A #125118

How to Group Data Month when Using Datetime Column MySQL >

Try this:

GROUP BY date(ActionTime) or:

Assuming you store the date and time under the datetime column, to query it you want to count the results according to group by date, below is the format:

SELECT DATE_FORMAT(postdate, '%Y-%m-%d') AS dd, COUNT(id) FROM MyTable GROUP BY dd;

Or you can also try the upgraded query and use the string below:

SELECT substring(postrdate, 1,10) AS dd, COUNT(id) FROM MyTable GROUP BY dd;

This works faster than the first, but whichever works for you, will do.

For more information, click the link below:

Commands on MySQL Date and Time Functions

About andre ford

Questions
3

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/01/2011
• Question Category: Software Others