oracle date类型比较查询

SELECT loginname,endtime FROM dailysessionpre_table  where days='2020-11-16' and length(ACCTSESSIONTIME) > 30 and endtime
between
              to_date('15/11/2020 23:45:00', 'dd/MM/yyyy hh24:mi:ss') and
              to_date('16/11/2020 00:15:00', 'dd/MM/yyyy hh24:mi:ss');
              
SELECT loginname,endtime FROM dailysessionpre_table  where days='2020-11-16' and length(ACCTSESSIONTIME) > 30 and endtime < to_date('16/11/2020 00:15:00', 'dd/MM/yyyy hh24:mi:ss');