select * from xx where creattime >'2013-01-01'

这样是无效的  关键是又不报错   改一下如下即可  select * from xx where creattime > date('2013-01-01')