MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: grouping of second by second records
Posted by: Peter Brawley
Date: April 27, 2014 08:32PM

eg group by cashier and 15-min bands of timecol:

... group by cashier, ( 4 * hour(timecol) + floor( minute(timecol) / 15 )) ...

For more on such logic see "Group data by datetime periods" at http://www.artfulsoftware.com/queries.php

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


Subject
Written By
Posted
grouping of second by second records
Roberto B.
April 27, 2014 02:09PM
Re: grouping of second by second records
Peter Brawley
April 27, 2014 08:32PM
Re: grouping of second by second records
Roberto B.
April 29, 2014 02:41PM
Re: grouping of second by second records
Peter Brawley
April 29, 2014 06:10PM
Re: grouping of second by second records
Rick James
May 02, 2014 11:18AM
Re: grouping of second by second records
Roberto B.
May 03, 2014 03:49AM


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.