正文

1.首先查看日志的时间格式：

2022-07-07 14:42:00.017 [pool-8-thread-1] DEBUG c.s.m.b.s.p.s.m.P.deleteByType - <==    Updates: 0 [BaseJdbcLogger.java:159] 
2022-07-07 14:42:00.017 [pool-8-thread-1] DEBUG c.s.m.b.s.p.s.m.P.insertRes10 - ==>  Preparing: insert into wp_monitor (record_id,area,analysistype,analysisvalue) SELECT 10,AREA.CITY_AREA ,10, SUM(DECODE(T.ID, NULL, 0, 1)) FROM (SELECT T1.* FROM RES_EQP T1,RES_R_RECORD_ENTITY T2,RES_RECORD T3 WHERE T1.ID=T2.ENTITY_ID AND T2.RECORD_ID=T3.ID AND T3.TYPE_ID=103141) T, (SELECT NVL((SELECT NAME FROM RES_AREA WHERE FULL_NAME = SUBSTR(A.FULL_NAME, 1, INSTR(A.FULL_NAME, '.', 1，2) - 1)), A.NAME) CITY_AREA, A.* FROM RES_AREA A WHERE A.PARENT_ID IS NOT NULL) AREA WHERE T.AREA_ID(+) = AREA.ID GROUP BY AREA.CITY_AREA  [BaseJdbcLogger.java:159] 
2022-07-07 14:42:00.017 [pool-8-thread-1] DEBUG c.s.m.b.s.p.s.m.P.insertRes10 - ==> Parameters:  [BaseJdbcLogger.java:159] 
2022-07-07 14:42:00.017 [pool-8-thread-1] DEBUG c.s.m.b.s.p.s.m.P.insertRes10 - <==    Updates: 0 [BaseJdbcLogger.java:159] 

2.可以看出时间格式是 2022-07-07 14:42:00.017 这种形式的。

3.由于日志太大很多情况不方便查看更不方便回传数据等等，这里我只截取14点42到45分的日志，可以这样写：

sed -n '/2022-07-07 14:42:00.017/,/2022-07-07 14:45:00.013/p' nohup.log >newlog.log

4.截取完毕，查看新文件即可，会正则表达式截取会更灵活哦。