projects
/
zc
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
draw graphs by_temp buckets daily
[zc]
/
gnuplot
/
by_temp.sql
1
select
2
to_char(min(time), 'YYYY-MM-DD') as time,
3
avg(x_axis_angle) ,
4
avg(y_axis_angle) ,
5
avg(sensor_temperature) ,
6
round((sensor_temperature / 2)) * 2
7
from zc
8
where pn = 2008050087 -- and time > now() - interval '24 hours'
9
group by
10
to_char(time, 'YYYY-MM-DD'),
11
round((sensor_temperature / 2)) * 2
12
order by time asc
13