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 b
In the last episode (Apr 29), David Lindelf said:
> Is there an easy way to get the last timestamped record not later
> than a given date/time?
>
> I record data for a scientific application and I do not sample my
> data at a given, fixed frequency. Instead, whenever a physical value
> changes bey
