title: sqlite3.OperationalError: default DATE value of column is not constant
body: <p>I am creating a sqlite3 table that accepts records from a server.  There should be one date/text column that also has a <code>datetime</code> DEFAULT value, so I can sync a record which times differ from the server's record.</p>
  <p>I found a solution on this forum from <a href="https://stackoverflow.com/questions/200309/sqlite-database-default-time-value-now">here</a>.  The problem is it gives me the following error on executing the table creation script: <code>sqlite3.OperationalError: default value of column [updated_at] is not constant</code>.</p>
  <p>Table is created:</p>
  <pre><code>cur.execute('CREATE TABLE IF NOT EXISTS emp_tb(\
                      emp_id INTEGER PRIMARY KEY NOT NULL,\
                      emp_names TEXT NOT NULL,\
                      emp_number TEXT NOT NULL UNIQUE,\
                      ent_id INTEGER NOT NULL,\
                      active INTEGER NOT NULL DEFAULT &quot;0&quot;,\
                      updated_at TEXT NULL DEFAULT (datetime(&quot;now&quot;, &quot;localtime&quot;)),\
                      syncstatus INTEGER NOT NULL DEFAULT &quot;0&quot;)')
  </code></pre>
  <p>Should I create a trigger? or How can I have a default value in format <code>(&quot;YYYY-MM-DD HH:MM:SS.SSS&quot;)</code> in case the update misses a spot?</p>