CREATE TABLE tblDates ('id' INTEGER PRIMARY KEY AUTOINCREMENT,'stamp' INTEGER);
70|1196420400
71|1196679600
72|1196766000
73|1196852400
74|1196938800
75|1197025200
76|1197284400
77|1197370800
78|1197457200
79|1197543600
81|1197630000
Is it possible to fetch id's 75, 76 and 77 if all I know is the stamp value of id 76?
Basically I need some SQL that pulls three rows based on a known stamp value plus the nearest higher stamp value and the nearest lower stamp value. It's entirely possible to id 82 could contain a stamp value that is lower than that of id 81.