CODE EXAMPLE FOR SQL

day of the week sqlite

# See https://www.sqlitetutorial.net/sqlite-date-functions/sqlite-strftime-function/
# for different parts of the date
SELECT strftime('%w', date_column) 
FROM table_n;