title: Inserting date string into SQLite from Python giving unexpected results
body: <p>As the title states, I'm trying to insert a date (formatted as a string) into a SQLite database. This works, however the date is not showing up correctly in SQLite.</p>
  
  <p>Here is a subset of my code:</p>
  
  <pre><code>print("Connecting to the database...")        
  sqlite_file = './sqlite_db/cfr_changes.db'
  conn = sqlite3.connect(sqlite_file)
  c = conn.cursor()
  
  
  today_date = datetime.now().strftime("%Y-%m-%d")
  print(today_date)
  print("Inserting tracker into database...")
  
  c.execute("INSERT INTO DATE (`date_id`) VALUES(" + today_date + ")")
  c.executemany("INSERT INTO TRACKER (`cfr_status`, `comment`, `mdu`, `iwb`, `obsolete`, `date_id`) VALUES(?,?,?,?,?, " + today_date + ")", list(tracker_df.to_records(index=False)))
  #print(c.fetchall())
  
  conn.commit()
  conn.close()
  </code></pre>
  
  <p>Printing 'today_date' returns what I'd expect:</p>
  
  <pre><code>2018-10-24
  </code></pre>
  
  <p>However when I check the records in SQLite through the terminal, the date is shown as:</p>
  
  <pre><code>1984
  </code></pre>
  
  <p>Note that 'date_id' is a VARCHAR(255), and date formatting should not be an issue. I would think that is simply a string being stored into a string (or close enough).</p>
  
  <p>Can anyone inform me why this doesn't work as expected?</p>
  
  <p>For reference, here is how the 'TRACKER' and 'DATE' tables were created:</p>
  
  <pre><code>CREATE TABLE `DATE` (
  `date_id` VARCHAR(255) NOT NULL PRIMARY KEY);
  
  CREATE TABLE `TRACKER` (
  `tracker_id` INTEGER NOT NULL PRIMARY KEY,
   `cfr_status` VARCHAR(255) NOT NULL,
  `mdu` BOOLEAN, `iwb` BOOLEAN,
  `obsolete` BOOLEAN, `comment` VARCHAR(255), `date_id` VARCHAR(255) NOT NULL, FOREIGN KEY (`date_id`) REFERENCES DATE(`date_id`));
  </code></pre>
  
  <p>Any help is appreciated.</p>