select *
from TEST_JOB t
WHERE to_char(t.para_date, 'YYYY/MM/DD HH24:MI:SS') between
'2016/11/08 10:55:18' and '2018/8/22 10:55:18'
to_char函数 转换时间格式
select *
from TEST_JOB t
WHERE to_char(t.para_date, 'YYYY/MM/DD HH24:MI:SS') between
'2016/11/08 10:55:18' and '2018/8/22 10:55:18'
to_char函数 转换时间格式