oracle between怎么用,oracle 的日期 between and 用法

//程序：

//介紹：

//如果downloadDateBegin 和 downloadDateEnd 日期不為空

//格式化日期

if(downloadDateBegin != null && downloadDateEnd != null){

SimpleDateFormat sf = new SimpleDateFormat("yyy-MM-dd HH:mm:ss");

String downloadDateBeginStr = sf.format(downloadDateBegin);

String downloadDateEndStr = sf.format(downloadDateEnd);

}

//sql:

SELECT a.* FROM "+TABLE_NAME+" a WHERE a.DATE_ between to_date('" +downloadDateBeginStr +"','yyyy-mm-dd hh24:mi:ss') and

to_date('" + downloadDateEndStr + "','yyyy-mm-dd hh24:mi:ss' ) ORDER BY a.DATE_ DESC";