query = "INSERT INTO temperatur(datum, uhrzeit, ort, messwert) VALUES(CURRENT_DATE(), NOW(), 'ort', messwert)";
curs.execute(query)

退出这个 - >

Warning: Data truncated for column 'uhrzeit' at row 1 curs.execute(query)
Warning: Data truncated for column 'ort' at row 1 curs.execute(query)

如何格式化CURRENT_DATE（）和NOW（）？ ort是一个字符串，乱七八糟地浮动

+----------+---------+------+-----+---------+----------------+
| Field    | Type    | Null | Key | Default | Extra          |
+----------+---------+------+-----+---------+----------------+
| id       | int(11) | NO   | PRI | NULL    | auto_increment |
| datum    | date    | YES  |     | NULL    |                |
| uhrzeit  | time    | YES  |     | NULL    |                |
| ort      | char(1) | YES  |     | NULL    |                |
| messwert | float   | YES  |     | NULL    |                |
+----------+---------+------+-----+---------+----------------+
mysql