Re: [sqlite] select where date < 30 days ago

[Miklos Koren]

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

[Miklos Koren]

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