select DATE_SUB(NOW(), INTERVAL 1 YEAR) 换成 dateadd(year,-1,NOW())

mysql 执行效果

mysql> select DATE_SUB(NOW(), INTERVAL 1 YEAR);
+----------------------------------+
| DATE_SUB(NOW(), INTERVAL 1 YEAR) |
+----------------------------------+
| 2022-10-18 18:00:24              |
+----------------------------------+
1 row in set (0.11 sec)

SQL> select dateadd(year,-1,NOW());

LINEID     DATEADD(YEAR,-1,NOW())    
---------- --------------------------
1          2022-10-18 18:01:08.981492