拼接CAST (栏位名 AS VARCHAR)
select curr_station station,CAST (year(modifydate) AS VARCHAR) +CAST ('\' AS VARCHAR)+ CAST (Right(100 + Month(modifydate), 2) AS VARCHAR) path from FLOW where sno = '003D' and curr_station in ('WOL4')
在小于10的月份前加0
Right(100 + Month(a.modifydate), 2)
获取日期中的year
year(modifydate)