java代码如下:
Date date=new Date();
SimpleDateFormat dateFormater = new SimpleDateFormat("yyyy-MM-dd");
String dateStr = dateFormater.format(date);//时间格式化得到字符串
String sql = "select db_test.* from db_test where date_format(db_test.time,'%Y-%m-%d') >= '"+dateStr+"'"
sql语句
//返回所有db_test.time在2017-01-01之后的数据
select db_test.* from db_test where date_format(db_test.time,'%Y-%m-%d') >= '2017-01-01'