List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 3 1999 11:18pm
Subject:Re: query question with timestamps
View as plain text  
At 1:12 AM +0200 7/4/1999, Norbert Kolb wrote:
>Is there a way to create a query which selects a timestamp, which is the
>closest to a given one ?
>
>Examples
>
>19990101
>19990202
>19990303
>
>Given: 19992702
>Result: 19990303
>
>Norbert

Select the timestamp and the difference between the timestamp and
the given value, sort on the difference, and apply LIMIT 1?

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
• root denied access on installScott Seller4 Jul
  • Re: root denied access on installDarrell Shifflett4 Jul
    • query question with timestampsNorbert Kolb4 Jul
      • Re: query question with timestampsPaul DuBois4 Jul
• Re: query question with timestampsPaul DuBois4 Jul