https://blog.csdn.net/fengxiaozhenjay/article/details/104302501 看看能不能帮到你

SELECT * 
  FROM SHIP_STATUS 
 WHERE SHIP_ID='ADASDAD' 
   AND UPDATE_DATE BETWEEN TO_DATE('2023-3-1 00:00:00','YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2023-3-1 23:59:59','YYYY-MM-DD HH24:MI:SS') 
   AND UNDERWAY_NOT_ASSESS=0;

用to_char拼把
select to_char(‘2023-03-03’,‘yyyy-mm-dd’)||’ 00:00:00’

select to_char(sysdate,‘yyyy-mm-dd “00:00:00”’);
select to_char(sysdate,‘yyyy-mm-dd “23:59:59”’);