Miklos, have you tried something like
SELECT * FROM ticket WHERE time BETWEEN '2011-08-01' AND '2011-09-01'; ? I have my "time" as current_timestamp and gives me data like "2011-09-23 17:44:48", so using the above method works just fine with me. >________________________________ >From: Miklos Koren <[email protected]> >To: [email protected] >Sent: Friday, September 16, 2011 3:01 PM >Subject: [sqlite] select where date < 30 days ago > >Hi, > >This is probably a basic SQL question, but I could not make it work under >sqlite. How do I select records for which a datetime column is less than >today - 30 days? I tried > >SELECT * FROM ticket WHERE time < DATETIME('now','-30 days'); > >but it does not give the intended results. > >Thanks, > >Miklos >_______________________________________________ >sqlite-users mailing list >[email protected] >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
