使用unix_timestamp方法进行比较,将字符型的时间,转成unix时间戳
select * from t1 where unix_timestamp(time1) > unix_timestamp('2011-03-03 17:39:05') and unix_timestamp(含有时间的字段) < unix_timestamp('2016-12-06');
使用unix_timestamp方法进行比较,将字符型的时间,转成unix时间戳
select * from t1 where unix_timestamp(time1) > unix_timestamp('2011-03-03 17:39:05') and unix_timestamp(含有时间的字段) < unix_timestamp('2016-12-06');