List:General Discussion« Previous MessageNext Message »
From:David Hillman Date:May 1 2006 3:54pm
Subject:Re: Timeseries
View as plain text  
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


Thread
TimeseriesDavid Lindelöf29 Apr
  • Re: TimeseriesDan Nelson29 Apr
  • Re: TimeseriesDavid Hillman1 May