title: QSqlQuery UPDATE/INSERT DateTime with server's time (eg CURRENT_TIMESTAMP)
body: <p>I am using QSqlQuery to insert data into a MySQL database.  Currently all I care about is getting this to work with MySQL, but ideally I'd like to keep this as platform-independent as possible.</p>
  
  <p>What I'm after, in the context of MySQL, is to end up with code that effectively executes something like the following query:</p>
  
  <pre><code>UPDATE table SET time_field=CURRENT_TIMESTAMP() WHERE id='5'
  </code></pre>
  
  <p>The following code is what I have attempted, but it fails:</p>
  
  <pre><code>QSqlQuery query;
  query.prepare("INSERT INTO table SET time_field=? WHERE id=?");
  query.addBindValue("CURRENT_TIMESTAMP()");
  query.addBindValue(5);
  query.exec();
  </code></pre>
  
  <p>The error I get is: <code>Incorrect datetime value: 'CURRENT_TIMESTAMP()' for column 'time_field' at row 1 QMYSQL3: Unable to execute statement</code>.  I am not surprised as I assume Qt is doing some type checking when it binds values.</p>
  
  <p>I have dug through the Qt documentation as well as I know how, but I can't find anything in the API designed specifically for supporting MySQL's CURRENT_TIMESTAMP() function, or that of any other DBMS.</p>
  
  <p>Any suggestions?</p>