mysql中datetime比较大小问题
摘要：
select sum(studychj) as tofflinejz from afterline where checkflag=1 and studytype=1 and studybegin>='2010-01-01 00:00:00' and studyend unix_timestamp('2011-03-03 17:39:05') and unix_timestamp(time1) = convert(date,表名.datetime列名) 三种方法待求证，总之是不要用字符串这么直接比 阅读全文
posted @ 2013-03-06 10:17 voker 阅读(12436) 评论(0) 推荐(0) 编辑
