hOme.beardedDonkey - SQLite How to select a particular day of the week using date function

SQLite How to select a particular day of the week using date function

Monday, July 15, 2019, 19:10 - How-Tos

This will select last Thursday's date:

SELECT date('now', 'weekday 4', '-7 days')

weekday 4 = Thursday, but if we want last week we have to -7 days from it.

If you want the date to be returned as unix epoch value, do the following:

SELECT strftime('%s', date('now', 'weekday 4', '-7 days'))

Comments

Comments are not available for this entry.