SELECT * from logininfo where userId=5 and day21>= 2012-12-01 15:59:34.0SELECT * from logininfo where userId=5 and day21>= 2012-12-01 15:59:34.0 其中 ‘2012-12-01 15:59:34.0’ 类型是Timestamp ,‘day21’ 类型是datetime .但是运行报的
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/22 11:33:45
![SELECT * from logininfo where userId=5 and day21>= 2012-12-01 15:59:34.0SELECT * from logininfo where userId=5 and day21>= 2012-12-01 15:59:34.0 其中 ‘2012-12-01 15:59:34.0’ 类型是Timestamp ,‘day21’ 类型是datetime .但是运行报的](/uploads/image/z/14925678-6-8.jpg?t=SELECT+%2A+from+logininfo+where+userId%3D5+and+day21%3E%3D+2012-12-01+15%3A59%3A34.0SELECT+%2A+from+logininfo+where+userId%3D5+and+day21%3E%3D+2012-12-01+15%3A59%3A34.0+%E5%85%B6%E4%B8%AD+%E2%80%982012-12-01+15%3A59%3A34.0%E2%80%99+%E7%B1%BB%E5%9E%8B%E6%98%AFTimestamp+%2C%E2%80%98day21%E2%80%99+%E7%B1%BB%E5%9E%8B%E6%98%AFdatetime+.%E4%BD%86%E6%98%AF%E8%BF%90%E8%A1%8C%E6%8A%A5%E7%9A%84)
SELECT * from logininfo where userId=5 and day21>= 2012-12-01 15:59:34.0SELECT * from logininfo where userId=5 and day21>= 2012-12-01 15:59:34.0 其中 ‘2012-12-01 15:59:34.0’ 类型是Timestamp ,‘day21’ 类型是datetime .但是运行报的
SELECT * from logininfo where userId=5 and day21>= 2012-12-01 15:59:34.0
SELECT * from logininfo where userId=5 and day21>= 2012-12-01 15:59:34.0 其中
‘2012-12-01 15:59:34.0’ 类型是Timestamp ,‘day21’ 类型是datetime .但是运行报的是StatementCallback; bad SQL grammar 错误.mysql datetime 对应的java时间类型不是Timestamp吗?
SELECT * from logininfo where userId=5 and day21>= 2012-12-01 15:59:34.0SELECT * from logininfo where userId=5 and day21>= 2012-12-01 15:59:34.0 其中 ‘2012-12-01 15:59:34.0’ 类型是Timestamp ,‘day21’ 类型是datetime .但是运行报的
SELECT * from logininfo where userId=5 and day21>= '2012-12-01 15:59:34.0'
时间那里,加上单引号.
再尝试一下看看.