数据库函数 截取日期格式记下来(不常用)
2020-09-08 本文已影响0人
S等价交换S
MySQL DATE_FORMAT() 函数
SELECT
start_date,
end_date,
category
FROM
erp_hr_leave_statistic
WHERE
DATE_FORMAT(start_date, '%Y-%m')
<= '2020-09'
MySQL DATE_FORMAT() 函数
SELECT
start_date,
end_date,
category
FROM
erp_hr_leave_statistic
WHERE
DATE_FORMAT(start_date, '%Y-%m')
<= '2020-09'