SELECT
*
FROM
abc
WHERE
TRANS_TIME
BETWEEN
"TO_DATE"('2018-04-23 10:38:00', 'yyyy-mm-dd hh24:mi:ss')
AND
"TO_DATE" ('2018-04-23 10:40:00','yyyy-mm-dd hh24:mi:ss');
或者
SELECT
*
FROM
abc
WHERE
TRANS_TIME
>
"TO_DATE"('2018-04-23 10:38:00', 'yyyy-mm-dd hh24:mi:ss')
AND
TRANS_TIME
<
TO_DATE ('2018-04-23 10:40:00','yyyy-mm-dd hh24:mi:ss');