mybaties将时间格式成字符串

最新推荐文章于 2024-04-17 23:25:20 发布

alex_mmg

最新推荐文章于 2024-04-17 23:25:20 发布

阅读量1.7k

点赞数

本文链接：https://blog.csdn.net/alex_mmg/article/details/78461807

版权

本文介绍了在MyBatis中如何将时间格式化为字符串，以便于进行按年月查询等操作。通过代码示例展示了具体的转换过程。

摘要由CSDN通过智能技术生成

有时候在做根据年月查询时要用到对时间切割字符串，代码如下：

select
  of.id,
  of.name,
    (select count(ctd.id) from car_train_driver ctd where ctd.done= '1' and ctd.car_train_id in
     (select id from car_train where parent_id in
      (select id from car_train where user_id in
       (select id from sys_user where office_id in
        (select id from  sys_office where parent_id in
         (select id from  sys_office where parent_id = of.id
         <if test="year !=null and year !=''">
            AND DATE_FORMAT(ctd.create_date,"%Y")= #{year}
         </if>
         <if test="month != null and month !=''">
            AND DATE_FORMAT(ctd.create_date,"%m")=#{month}
         </if>
         )
        )
       )
      )
     )
    ) num,
        format(if((select (sum(score)/(count(