回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<pre><code>Django failed to insert record into session after login with message:
--------------------------------------------------------------------
DatabaseError at /admin/
(-2147352567, 'Exception occurred.', (0, u'Microsoft OLE DB Provider for SQL Server', u'Conversion failed when converting date and/or time from character string.', None, 0, -2147217913), None)
Command:
INSERT INTO [django_session] ([session_key], [session_data], [expire_date]) VALUES (?, ?, ?)
Parameters:
[Name: p0, Dir.: Input, Type: adBSTR, Size: 32, Value: "orctnepzkaqb4haa6tn7jjit961a4l3s", Precision: 0, NumericScale: 0, Name: p1, Dir.: Input, Type: adBSTR, Size: 60, Value: "M2FiMTM4NGJmNjY4NDc2YjA0Y2I1ZjI4NDcxYzNlNTExYTljODYxMTp7fQ==", Precision: 0, NumericScale: 0, Name: p2, Dir.: Input, Type: adBSTR, Size: 26, Value: "2014-12-30T12:38:53.076000", Precision: 0, NumericScale: 0]
--------------------------------------------------------------------
</code></pre>
<p>如果你看2014-12-30T12:38:53.076000的日期,可以看出毫秒是由6位数字组成的。在</p>
<p>直接插入具有相同参数的数据库将返回相同的转换错误。在</p>
<p>如果将毫秒截断到3个字符,则插入操作将正常进行。在</p>
<p>django在何时何地以这种格式创建日期?在</p>
<p>此错误仅在生产环境中发生。
Python 2.7,Django 1.6.8,操作系统:Windows Server 2008R2,web服务器:IIS 7,DB服务器:MS SQL 2008R2</p>