I was finally able to make it work with WHERE CAST(time AS int)/1000000/86400+2440588 < JULIANDAY('now','-30days')
2011/9/16 Igor Tandetnik <itandet...@mvps.org> > > 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