Good afternoon - I have such a question there is a table with a list
id server_id time_date old_status new_status 100 55 2014-06-03 11:32:36 run 101 55 2014-10-03 10:15:36 run down 102 55 2014-10-06 10:33:36 down run 5604 56 2014-08-04 07:03:26 run down id - event number server_id - server name time_date - event time old_status - server status in the previous state new_status - modified state.
I need to know server uptime.
for example, as follows ( id means server identifier):
MySQL 5.6 Schema Setup :
create table vremena (id int, v datetime, s text); insert into vremena values (55, '2014-06-03 11:32:36', 'run'), (55, '2014-10-03 10:15:36', 'down'), (55, '2014-10-06 10:33:36', 'run'), (55, '2014-08-04 07:03:26', 'down'); Query 1 :
select sum( case when s = 'run' then - unix_timestamp(v) else unix_timestamp(v) end ) as vremja from vremena group by id Results :
| vremja | |---------| | 5080370 | for example, as follows ( id means server identifier):
MS SQL Server 2014 Schema Setup :
create table vremena (id int, v datetime, s varchar(4)); insert into vremena values (55, '2014-06-03 11:32:36', 'run'), (55, '2014-10-03 10:15:36', 'down'), (55, '2014-10-06 10:33:36', 'run'), (55, '2014-08-04 07:03:26', 'down'); Query 1 :
select sum( case when s = 'run' then - datediff(second, '19700101', v) else datediff(second, '19700101', v) end ) as vremja from vremena group by id Results :
| vremja | |---------| | 5080370 | 
Source: https://ru.stackoverflow.com/questions/439107/
All Articles