title: Openerp 7- how to run datetime update query
body: <p>I am having problem with this update query and I don't understand the error here. please help me to solve this.</p>
  
  <p><strong>Field</strong></p>
  
  <pre><code>'sign_in' : fields.datetime("Sign In"),
  </code></pre>
  
  <p><strong>Variable</strong></p>
  
  <pre><code>sgn_in1 = datetime.datetime.strptime(sign_in, DATETIME_FORMAT1).time()
  </code></pre>
  
  <p><strong>Query</strong></p>
  
  <pre><code>cr.execute("""UPDATE allowance.attendances SET sign_in = %s WHERE id =%s"""%(sign_in1,colmn_id))
  </code></pre>
  
  <p><strong>Error</strong></p>
  
  <blockquote>
    <p>ProgrammingError: syntax error at or near ":" LINE 1: UPDATE
    allowance.attendances SET sign_in = 08:15:00</p>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/Gwu5J.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Gwu5J.png" alt=""></a></p>