delete from MSS_RECORD where
    GMT_CREATED BETWEEN
          to_date(to_char(sysdate,‘yyyy-mm-dd‘) || ‘ 00:00:00‘,‘yyyy-mm-dd hh24:mi:ss‘) AND
          to_date(to_char(sysdate,‘yyyy-mm-dd‘) || ‘ 23:59:59‘,‘yyyy-mm-dd hh24:mi:ss‘) ;

删除当天记录