in reply to to_days(now())

The function you want is julianday(). More specifically, julianday('now'). See here for an example where I translated some statements from MySQL to SQLite.

mhoward - at - hattmoward.org

In Section Seekers of Perl Wisdom