Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Sql > merge timestamp...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 3460 of 3599
Post > Topic >>

merge timestamps to intervals

by Patrick Scharrenberg <pittipatti@[EMAIL PROTECTED] > May 11, 2008 at 09:40 AM

Hi!

I have a table where I repeatingly log the status of some service, which
looks something like this:

	< timestamp, status >

Now, everytime my service is up I save the timestamp and a status of
"up", if it's down I save the timestamp with "down", eg:
	10:13	up
	10:14	up
	10:15	up
	10:16	down
	10:17	up
	10:18	up

I'd like to merge this information to intervals where the service was up
or down.

	< intervall, status >
	10:13-10:15	up
	10:16-10:16	down
	10:17-1018	up

I've no clue how to approach this problem.

Any ideas/hints?

Thanks
Patrick
 




 1 Posts in Topic:
merge timestamps to intervals
Patrick Scharrenberg <  2008-05-11 09:40:02 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 12:50:03 CDT 2008.