select * from table1 where create_time>'2014-03-21 00:00:00'
查询可以直接比较 例如:select * from table where createtime>='2014-01-01 00:00:00' and creattime<'2014-01-31 00:00:00';如果要批量显示可以这样 select *, unix_timestamp(createtime) as createtime from table;
select * from table where createtime>='2014-01-01 00:00:00' and creattime<'2014-01-31 00:00:00';
数据库里不是一条数据,那么多数据怎么转
例如:select * from table where createtime>='2014-01-01 00:00:00' and creattime<'2014-01-31 00:00:00';如果要批量显示可以这样
select *, unix_timestamp(createtime) as createtime from table;