[Kit]
> SELECT a.temp+(b.temp-a.temp)/(b.time-a.time)*(strftime('%s','2012-02-08
> 11:37:00')-a.time) FROM
> (select time, temp FROM tp
> WHERE strftime('%s','2012-02-08 11:37:00')*1>=time
> ORDER BY time DESC LIMIT 1) AS a,
> (select time, temp FROM tp
> WHERE strftime('%s','2012-02-08 11:37:00')*1<time
> ORDER BY time LIMIT 1) AS b;
Thanks! I will try to rewrite this as a view.
--
Steinar
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
