Miklos Koren <miklos.ko...@gmail.com> wrote: > I was finally able to make it work with > > WHERE CAST(time AS int)/1000000/86400+2440588 < JULIANDAY('now','-30days')
It appears your timestamp is in microseconds since 1/1/1970. In this case, it might be a bit more straightforward to write where time < strftime('%s', 'now', '-30 days') * 1000000 -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users