SQLite Forum

select between two dates
Login
strftime('%s', 'now', '-14 days') yields the unix epoch second count 14 days prior to now (the time the statement commenced execution) as a character string (not as an integer).

strftime('%s') yields the now (the time the statement commenced execution) second count since the unix epoch as a character string (not as an integer).