Oracle的时间查询语句

public static final String TIME_BEGIN = " 00:00:01";

public static final String TIME_END = " 23:59:59";

"select count(balance) as BALANCE from CardTransaction where shopflag=" + shopFlag + " and flag=" + jiaoyiFlag + " and optime between to_Date('" + date + TIME_BEGIN + "','yyyy-mm-dd hh24:mi:ss') and to_Date('" + date + TIME_END + "', 'yyyy-mm-dd hh24:mi:ss')"

这个语句中date的类型为String类型