MySQL Forums :: Newbie :: scanning for data gaps in time series


Advanced Search

scanning for data gaps in time series
Posted by: Sidney Kwakkel ()
Date: July 13, 2011 05:55PM

I have a table as follows

datetime | value
-------------------------------
2011-01-01 02:00:00 | 1.2
2011-01-01 02:02:00 | 1.4
2011-01-01 02:06:00 | 1.4
2011-01-01 02:08:00 | 1.1
2011-01-01 02:10:00 | 1.6
2011-01-01 02:16:00 | 1.5
2011-01-01 02:18:00 | 1.1

I want to scan the time series for intervals that are greater than two minutes and gives the following result

starttime | endtime | gap
------------------------------------------------
2011-01-01 02:02:00 | 2011-01-01 02:06:00 | 4
2011-01-01 02:10:00 | 2011-01-01 02:16:00 | 6

Options: ReplyQuote


Subject Written By Posted
scanning for data gaps in time series Sidney Kwakkel 07/13/2011 05:55PM
Re: scanning for data gaps in time series Peter Brawley 07/13/2011 06:58PM
Re: scanning for data gaps in time series Sidney Kwakkel 07/14/2011 12:12PM
Re: scanning for data gaps in time series Peter Brawley 07/14/2011 03:57PM
Re: scanning for data gaps in time series Peter Brawley 07/15/2011 07:18AM
Re: scanning for data gaps in time series laptop alias 07/14/2011 05:13PM
Re: scanning for data gaps in time series Peter Brawley 07/14/2011 05:30PM
Re: scanning for data gaps in time series Rick James 07/15/2011 10:09PM
Re: scanning for data gaps in time series Peter Brawley 07/16/2011 03:30AM
Re: scanning for data gaps in time series laptop alias 07/16/2011 05:12AM
Re: scanning for data gaps in time series Peter Brawley 07/16/2011 12:09PM
Re: scanning for data gaps in time series laptop alias 07/16/2011 12:48PM
Re: scanning for data gaps in time series Rick James 07/16/2011 01:25PM
Re: scanning for data gaps in time series laptop alias 07/16/2011 03:11PM


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.