The following query returns no results, when there should be many. Can anyone tell me what I'm doing wrong?

SELECT latitude, longitude
FROM data_hist
WHERE server_ts BETWEEN sysdate() AND sysdate() - 100000
ORDER BY server_ts ASC

Thanks in advance!

Not sure what you mean by subtracting an integer (100000) from a date. You'd do better using the date_add function.

Mike

it's hard to tell from what little information you've provided

please do a SHOW CREATE TABLE

also, i'm curious how a lat/long data point would be time-sensitive

a lat/long reflects a physical co-ordinate which may have been recorded at a specific point in time as a position.

I don't see any problem in looking for positions over a specific date/time span.