我把我的应用从SQLite切换到了MySQLSELECT DATE_FORMAT(datetime, '%Y-%m-%d %H:00:00') as datetime FROM () AS T GROUP BY datetime
在SQLIte中,GROUP BY datetime是在格式化日期求值的,因
我的约会时间是这样进入数据库的:$DateTime = strftime("%b-%d-%Y %H: %M: %S", $CurrentTime);"SELECT * FROM admin_panel WHERE MONTH(datetime) ='2'"
"SELECT * FROM admin_panel WHERE MONTH(STR_TO_DATE(datetime,