回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>两个日期之间的差异存储在MySQL中。在</p>
<p>运行以下代码:</p>
<pre><code>import datetime
import time
from time import sleep
import MySQLdb as mdb
connection = mdb.connect('localhost', 'root', 'pwd', 'mydatabase');
cursor = connection.cursor()
TimeFormat = '%Y-%m-%d %H:%M:%S'
#Insert times and type of event into database
with connection:
#First event
Now=datetime.datetime.now()
Timewhen1=Now.strftime(TimeFormat)
print "Start time", Timewhen1
Type="1"
cursor.execute('INSERT INTO LogEvent (Timewhen, Type) VALUES (%s, %s)',(Timewhen1,Type))
sleep(1) #Real time will be unknown, seconds to days
#Second event
Now=datetime.datetime.now()
Timewhen2=Now.strftime(TimeFormat)
print "Stop time", Timewhen2
Type="0"
cursor.execute('INSERT INTO LogEvent (Timewhen, Type) VALUES (%s, %s)',(Timewhen2,Type))
#Get time difference
with connection:
cursor.execute("SELECT Timewhen FROM LogEvent ORDER BY ID DESC LIMIT 0,1")
result=cursor.fetchone()
cursor.execute("SELECT Timewhen FROM LogEvent ORDER BY ID DESC LIMIT 1,1")
result2=cursor.fetchone()
diff=result2-result
print "Diff", diff
</code></pre>
<p>得到以下结果:</p>
<blockquote>
<p>TypeError: unsupported operand type(s) for -: 'tuple' and 'tuple'</p>
</blockquote>
<p>result/result2的格式为<code>(datetime.datetime(2017, 1, 27, 22, 25, 39),)</code>。在</p>
<p>我想我在tuple/string格式上做错了什么。感谢任何帮助!在</p>