MySQL Forums
Forum List  »  Views

Re: grouping date ranges
Posted by: Peter Brawley
Date: October 22, 2010 07:22AM

If what you mean by "absolute date boundaries" were clear from your example, I wouldn't have asked. I have no idea what's unsatisfactory about the result of:

select sampInt, min(start), max(end) group by 1;

PB

Options: ReplyQuote


Subject
Views
Written By
Posted
3516
October 21, 2010 02:55AM
1540
October 21, 2010 07:35AM
1445
October 21, 2010 07:47AM
Re: grouping date ranges
1528
October 22, 2010 07:22AM
1636
October 22, 2010 07:38AM
1472
October 22, 2010 08:17AM


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.