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
