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');
阅读(1233) | 评论(0) | 转发(0) |
