SQLAlchemy 往 MySQL 里存入日期字符串 '2019/07/01'，为什么总是被警告？ Warning: (1292, "Truncated incorrect DOUBLE value: '2019/07/01'")

推荐学习书目

› Learn Python the Hard Way

Python Sites

› PyPI - Python Package Index

› Pocoo

值得关注的项目

› PyPy

› pyenv

Python 编程

› pep8 Checker

Styles

› PEP 8

This topic created in 2666 days ago, the information mentioned may be changed or developed.

date_str = datetime.utcnow().strftime('%Y/%m/%d')

可以存，但是总是被警告：

Warning: (1292, "Truncated incorrect DOUBLE value: '2019/07/01'") cursor.execute(statement, parameters)

3 replies • 2019-07-21 21:49:07 +08:00

loading

Jul 21, 2019 via Android

大家不用回答，楼主自己搜索
1292, "Truncated incorrect DOUBLE value:

runze

Jul 21, 2019

starsriver

Jul 21, 2019 via Android

看见这个我就想笑了。