MySQL Forums
Forum List  »  Quality Assurance

Sum up data for sequential dates
Posted by: Jaimie Logan
Date: May 29, 2012 01:36PM

I am trying to do a summation of increments over a two-day period. I have a Date_Time column, though not all of the days are there and I only want days that are in a row.

Date_Time Increment
1996-07-09 0.16
1996-07-14 0.27
1996-07-15 0.04
1996-07-25 0.08
1996-07-26 0.08
... ...

So there would be a two-day sum from the 14th-15th and from the 25th-26th, but not for the days that are not sequential.

Edited 1 time(s). Last edit at 05/29/2012 01:38PM by Jaimie Logan.

Options: ReplyQuote

Written By
Sum up data for sequential dates
May 29, 2012 01:36PM

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.