MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: grouping by time periods
Posted by: Peter Brawley
Date: September 26, 2007 09:27AM

Look again. You transcribed the formula incorrectly. Try

GROUP BY ( 3 * HOUR( calldate ) + FLOOR( MINUTE( calldate ) / 20 ) )

PB

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


Subject
Written By
Posted
grouping by time periods
brian Johnson
September 25, 2007 02:06AM
Re: grouping by time periods
Anthony Willard
September 25, 2007 06:57AM
Re: grouping by time periods
Peter Brawley
September 25, 2007 07:03AM
Re: grouping by time periods
brian Johnson
September 26, 2007 08:24AM
Re: grouping by time periods
Peter Brawley
September 26, 2007 09:27AM
Re: grouping by time periods
brian Johnson
October 01, 2007 04:48AM
Re: grouping by time periods
Peter Brawley
October 01, 2007 08:42AM
Re: grouping by time periods
brian Johnson
October 01, 2007 05:51AM
Re: grouping by time periods
brian Johnson
October 01, 2007 11:22AM
Re: grouping by time periods
Peter Brawley
October 01, 2007 02:35PM
Re: grouping by time periods
brian Johnson
October 02, 2007 02:22AM
Re: grouping by time periods
Peter Brawley
October 02, 2007 11:59AM
Re: grouping by time periods
brian Johnson
October 03, 2007 04:47AM
Re: grouping by time periods
Peter Brawley
October 03, 2007 09:55AM
Re: grouping by time periods
brian Johnson
October 04, 2007 02:35AM
Re: grouping by time periods
Peter Brawley
October 04, 2007 09:23AM
Re: grouping by time periods
brian Johnson
October 04, 2007 10:41AM
sample data please
Peter Brawley
October 04, 2007 10:49AM
Re: sample data please
brian Johnson
October 15, 2007 06:52AM
Re: sample data please
Peter Brawley
October 15, 2007 09:55AM
Re: grouping by time periods
Kyle butler
October 08, 2007 08:05AM
Re: grouping by time periods
Peter Brawley
October 08, 2007 10:27AM


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.