这个简单!用这个好啦! SELECT * FROM mytable WHERE CONVERT(CONCAT(MyDate,' ',MyTime),DATETIME)>DATE_FORMAT('1999-12-6 8:13:25','%Y-%m-%d %H:%I:%i') AND CONVERT(CONCAT(MyDate,' ',MyTime),DATETIME)<DATE_FORMAT('2000-12-6 5:13:25','%Y-%m-%d %H:%I:%i')
SELECT DATE_ADD(CONCAT(date,time),INTERVAL 0 SECOND) AS datetime FROM tabale HAVING datetime>=1999-12-6 8:13:25’AND datetime<=2000-12-6 5:13:25’;
to lehool(爱生活,爱精彩!) 我试过了 .执行通过,可就是返回空值呀,,本来我已经有符合条件的记录在数据库中.可就是返回空
SELECT *
FROM mytable
WHERE CONVERT(CONCAT(MyDate,' ',MyTime),DATETIME)>DATE_FORMAT('1999-12-6 8:13:25','%Y-%m-%d %H:%I:%i')
AND CONVERT(CONCAT(MyDate,' ',MyTime),DATETIME)<DATE_FORMAT('2000-12-6 5:13:25','%Y-%m-%d %H:%I:%i')
我试过了 .执行通过,可就是返回空值呀,,本来我已经有符合条件的记录在数据库中.可就是返回空