这里做了几个测试
  select * from simingpai where TIMESTAMP(createTime) >= '2015-9-6';
  select * from simingpai where TIMESTAMP(createTime) >= '2015-9-6 00:00:00';
  select * from simingpai where TIMESTAMP(createTime) >= '2015-9-6 18:15:00';
  select * from simingpai where DATE(createTime) >= '2015-9-6';
  select * from simingpai where DATE(createTime) >= '2015-9-6 00:00:00';
  select * from simingpai where DATE(createTime) >= '2015-9-6 00:00:01';
  select * from simingpai where DATE(createTime) >= '2015-9-6 18:15:00';
  这几条语法都没有问题,TIMESTAMP类型支持时分秒,DATE类型第一条和第二条输出结果相同(估计是忽略了后面的时分秒),但是第三条和第四条语句会报错。应该是不支持时分秒。
  select * from simingpai where TIMESTAMP(createTime) >= 2015-9-6;
  select * from simingpai where TIMESTAMP(createTime) >= 2015-9-6 00:00:00;
  select * from simingpai where TIMESTAMP(createTime) >= 2015-9-6 18:15:00;
  select * from simingpai where Date(createTime) >= 2015-9-6;
  select * from simingpai where DATE(createTime) >= 2015-9-6 00:00:00;
  select * from simingpai where DATE(createTime) >= 2015-9-6 00:00:01;
  select * from simingpai where DATE(createTime) >= 2015-9-6 18:15:00;
  这里的SQL语句中TIMESTAMP类型和DATE类型的第一条语句能输出结果,其他的都不正确。这种格式应该不支持时分秒。