From: Dobrica Pavlinusic Date: Tue, 6 Oct 2020 10:21:11 +0000 (+0200) Subject: reformat, added pn to where X-Git-Url: http://git.rot13.org/?p=zc;a=commitdiff_plain;h=0c580c59bdfddd59180ed0daa4329cbb2c0f3760 reformat, added pn to where --- diff --git a/gnuplot/axes.sql b/gnuplot/axes.sql index 11522de..b5f6af6 100644 --- 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