查找时间范围时用的SQL语句

 if (this.txtapplRegDate.Value.Trim() != "")        //登记日期
        {
            sqlStr.Append(" and applRegDate >= '" + this.txtapplRegDate.Value + " 00:00:00'");
        }