send email and sms alerts

[zc] / gnuplot / axes.sql

diff --git a/gnuplot/axes.sql b/gnuplot/axes.sql
index 11522de..b5f6af6 100644 (file)
--- a/gnuplot/axes.sql
+++ b/gnuplot/axes.sql
@@ -1,2 +1,5 @@
-select to_char(time, 'YYYY-MM-DD HH24:MI:SS'), x_axis_angle, y_axis_angle from zc where time > now() - interval '6 hours' order by time asc 
+select to_char(time, 'YYYY-MM-DD HH24:MI:SS'), x_axis_angle, y_axis_angle
+from zc
+where pn = 2008050087 and time > now() - interval '24 hours'
+order by time asc