SQLite How to select a particular day of the week using date function 
Monday, July 15, 2019, 19:10 - How-Tos
Posted by Nathan
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'))


[ view entry ] ( 691 views )   |  [ 0 trackbacks ]   |  permalink  |   ( 3.1 / 895 )

<<First <Back | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | Next> Last>>