SQLite Forum

Getting rid of double DATE()
Login
> If I change what I put into lastUsed, I have to change it in both places.

Yes.

 > When the statement is executed just when the day changes, they could give different results.

That cannot happen.  'now' is step stable by default.  And the entire statement runs to completion in a single step.