创建一临时表:

create table test_view as select * from test where date(to_timestamp(endtime))>='2012-09-02';

参考

05-11 22:12