我有一个表,有3列:ID; TIMEON; TIMEOFF; TIMES
和数据
22 | 2016-05-25 19:17:11 | 2016-05-26 18:26:43 | 0000-00-00 00:00:00
#!/usr/bin/env python
import time
import MySQLdb
import RPi.GPIO as GPIO
import datetime
from datetime import datetime
from time import localtime, strftime, strptime
db = MySQLdb.connect(host="localhost", user="123", passwd="tesst", db="raspi")
cur= db.cursor()
cur.execute("SELECT TIMEON, TIMEOFF FROM DP WHERE Id = 22")
time_results = cur.fetchall()
for row in time_results:
tgianON = row[0]
tgianOFF = row[1]
aaa = abs(tgianOFF - tgianON)
print aaa
cur.execute("UPDATE DP SET TIMEUSE=%s WHERE Id = %s",(aaa, 22))
db.commit()
cur.close()
db.close()
TIMEON
和TIMEOFF
之间的时间,然后将其插入到当前行中的mysql(TIMES
在我的表中),但运行时出错:22:46:54
tet.py:17: Warning: Out of range value for column 'TIMEUSE' at row 1 cur.execute("UPDATE DP SET TIMEUSE=%s WHERE Id = %s",(aaa, 22))
我认为aaa
的格式是错误的。对吗?你知道吗
目前没有回答
相关问题 更多 >
编程相关推荐