MySQL Forums :: Newbie :: Grouping by hour, day, weekday, week, month and year


Advanced Search

Grouping by hour, day, weekday, week, month and year
Posted by: Kashif Butt ()
Date: September 17, 2011 07:29AM

Hello.

I would like to group data according to hour, day, weekday, week, month and year based on one date column. My other problem is that I want to calculate data from 4am the first day till 3.59am the last day!

For example, the query for a week should be retrieve data from Monday 4am till the next Monday 3.59am. Same goes for month and year.

Many thanks

Options: ReplyQuote


Subject Written By Posted
Grouping by hour, day, weekday, week, month and year Kashif Butt 09/17/2011 07:29AM
Re: Grouping by hour, day, weekday, week, month and year laptop alias 09/17/2011 09:12AM
Re: Grouping by hour, day, weekday, week, month and year Rick James 09/19/2011 08:17AM
Re: Grouping by hour, day, weekday, week, month and year Kashif Butt 09/19/2011 02:35PM
Re: Grouping by hour, day, weekday, week, month and year Kashif Butt 09/19/2011 03:26PM
Re: Grouping by hour, day, weekday, week, month and year Rick James 09/21/2011 11:45PM
Re: Grouping by hour, day, weekday, week, month and year Kashif Butt 09/26/2011 02:24PM
Re: Grouping by hour, day, weekday, week, month and year Rick James 09/28/2011 10:14AM
Re: Grouping by hour, day, weekday, week, month and year Kashif Butt 10/02/2011 10:21PM
Re: Grouping by hour, day, weekday, week, month and year laptop alias 10/03/2011 12:36AM
Re: Grouping by hour, day, weekday, week, month and year Kashif Butt 10/04/2011 11:07AM


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.