MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Group transactions by week
Posted by: Felix Geerinckx
Date: August 17, 2005 01:38PM

Carlos Rosero wrote:

> I am having problems finding how to group transactions by week,

I usually GROUP BY DATE_FORMAT(thedate, '%x-%v'), but your mileage may vary. See http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html for other options.

--
felix
Please use BBCode to format your messages in this forum.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Group transactions by week
Carlos Rosero
August 17, 2005 01:18PM
Re: Group transactions by week
Felix Geerinckx
August 17, 2005 01:38PM
Re: Group transactions by week
Arie Nagel
August 17, 2005 01:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.