SQL查询日期字段=日期字段+时分秒语句

admin

select
to_char(a.check_time,'yyyy-mm-dd hh24:mi:ss'),
to_date(to_char((a.check_time+interval '440608' second),'yyyy/mm/dd hh24:mi:ss'),'yyyy/mm/dd hh24:mi:ss'),  --秒：second
      from peaas.presc a
where a.check_state = 2
and a.check_error_flag = 1
and a.received_doctor_code is not null
and a.presc_date <= to_date('2026-01-01', 'yyyy-mm-dd')
and a.presc_no='17567206601390084752';