13 3月 Extracting specific records from a SQLite3 table in a certain time window SQL, Tips 2014.3.13. nagae 0 Suppose mytable has two columns: date_time as TEXT (formatted as ‘%Y-%m-%d %H:%M’) customer_ID as … 続きを読む
13 3月 Difference in weekday between Python and SQLite3 Python, SQL, Tips 2014.3.13. nagae 0 Python (in datetime package): import datetime datetime.date.today().weekday() 0 = Monday 1 = Tuesday 2 = Wedne … 続きを読む