获取当月第一天：

1

DATE_ADD(curdate(),interval -day(curdate())+1 day))

1

ADDDATE(NOW(), INTERVAL -#{start} MONTH)

1

%Y-%m-%d %T

Oracle:

1

(SYSDATE- STR_TO_DATE(b.CREATE_TM, '%Y-%m-%d %T'))*24*60)

转换为： MySQL:

1

(TO_DAYS(NOW()) - TO_DAYS(STR_TO_DATE("2022-11-26 11:11:11","%Y-%m-%d %T")))*24*60