select to_char(time, 'YYYY-MM-DD HH24:MI:SS'), x_axis_angle, y_axis_angle, sensor_temperature, power_source_voltage
from zc
where pn = 2008050087 -- and time > now() - interval '24 hours'
order by time asc 

