<p>如何使用pymssql插入datatime对象?我知道SQL Server表需要一个datetime对象,比如说在位置3。我试过这三种方法:</p>
<pre><code>cursor.execute("INSERT INTO MyTable VALUES(1, 'Having Trouble', datetime.datetime.now())")
cursor.execute("INSERT INTO MyTable VALUES(1, 'Having Trouble', 20130410)")
cursor.execute("INSERT INTO MyTable VALUES(1, 'Having Trouble', '20130410')")
cursor.execute("INSERT INTO MyTable VALUES(1, 'Having Trouble', GETDATE())")
</code></pre>
<p>每次我都会得到同样的错误:</p>
<pre><code>OperationalError: (241, 'Conversion failed when converting date and/or time from character string.DB-Lib error message 241, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n')
</code></pre>
<p>我搜遍了那里的小文件,反复搜遍了。</p>
<p>您可以使用以下代码:</p>
<pre><code># a tuple with the data to be stored in db
data = (1, 'Having Trouble', datetime.datetime.now())
# perform the query
cursor.execute("INSERT INTO MyTable VALUES(%s, %s, %s)" % data)
</code></pre>