java加mysql按时间条件查询sql语句

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'