On Apr 28, 2006, at 7:12 PM, David Lindelöf wrote:
Is there an easy way to get the last timestamped record not later
than a
given date/time?
Well, yeah, that part is easy.
select * from your_table where timestamp target_time order by
timestamp desc limit 1
Your problem seems to
which is stored
in the database.
For data analysis however it is more convenient to have a
regularly-spaced timeseries of that data. For instance, if I get
temperature measurements at 7:56, 8:02, 8:13 and 8:27, and would like a
timeseries 15-minutes apart (8:00, 8:15, 8:30), I would like MySQL
a given threshold, I get a new timestamped value which
is stored in the database.
For data analysis however it is more convenient to have a
regularly-spaced timeseries of that data. For instance, if I get
temperature measurements at 7:56, 8:02, 8:13 and 8:27, and would like
a timeseries 15