select *
from ST_RIVER_R t
where stcd='50101100' and tm
between to_date('2018-01-01 ','yyyy-mm-dd ')
and to_date('2018-05-30 01:00:00','yyyy-mm-dd hh24:mi:ss')
使用日期函数
to_date('2018-01-01 ','yyyy-mm-dd ')
to_date('2018-05-30 01:00:00','yyyy-mm-dd hh24:mi:ss')