遇的问题
1、sql日期转换报错
select ProductionDate,DeptName,BranchCode, BranchName,WorkshopCode,WorkshopName,item,HaltName, SUM(HaltPeriod) AS HaltPeriod , case bz when 'A' then '甲' when 'B' then '乙' when 'C' THEN '丙' end as BZ from bus_gtd where valid='1' and DeptName='炼铁事业部' and convert(varchar(10),ProductionDate,120) ='${GtoDate}' group by ProductionDate,DeptName,BranchCode,BranchName,WorkshopCode,WorkshopName,BZ,item,HaltName ORDER BY BranchCode,WorkshopCode,bus_gtd.BZ
sql 里将日期型转成字符型
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步