获取当月第一天：

1
2
3



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

1
2
3



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

1
2
3



%Y-%m-%d %T

Oracle:

1
2
3



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

转换为：

MySQL:

1
2
3



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