Re: Timeseries

[David Hillman]

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 be how to get multiple "last-timestamped  
records", and I don't think that answer will be elegant.

--
David Hillman
LiveText, Inc
1.866.LiveText x235