获取前时间 SYSDATE
select TO_CHAR(SYSDATE, 'yyyy-mm-dd hh24:mi:ss') as a from dual;
通过日期字符串进行查询
select * from TS_HYDROGEN_RECORD where END_TIME < to_date('2022-01-24 00:00:00', 'YYYY-MM-dd HH24:mi:ss')
获取前时间 SYSDATE
select TO_CHAR(SYSDATE, 'yyyy-mm-dd hh24:mi:ss') as a from dual;
通过日期字符串进行查询
select * from TS_HYDROGEN_RECORD where END_TIME < to_date('2022-01-24 00:00:00', 'YYYY-MM-dd HH24:mi:ss')