title: Naming a table in sqlite3
body: <p>I am trying to use Python to set the name of a table to the current datetime.  However, I keep getting a syntax error.  I have tried a couple different things which you'll see below.  Please help if you can.  Thanks!</p>
  
  <p>Option One:</p>
  
  <pre><code>import sqlite3, datetime
  con = sqlite3.connect('test.db')
  cur = con.cursor()
  cur.execute("CREATE TABLE datetime.datetime.now().strftime('%Y%d%m')(col1 TEXT, col2 TEXT)")
  </code></pre>
  
  <p>Option Two:</p>
  
  <pre><code>import sqlite3, datetime
  con = sqlite3.connect('test.db')
  cur = con.cursor()
  varOne = datetime.datetime.now(strftime('%Y%d%m')
  cur.execute("CREATE TABLE {tn} (col1 TEXT, col2 TEXT)".format(tn = varOne))
  </code></pre>
  
  <p>Both of these give the same Operational Error near [some character]: syntax error.  Any ideas?</p>