Re: [sqlite] select where date < 30 days ago
I was finally able to make it work with WHERE CAST(time AS int)/100/86400+2440588 < JULIANDAY('now','-30days') 2011/9/16 Igor Tandetnik > > Show your data, show the results you get from the statement, and explain > how the observed outcome differs from your expectations. > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users