SQL
数据库里面的:
CAST(DATEPART(yy,T_attemperPlantVehicleMain.ComputeVehicleDate) AS varchar(50)) + '-' + CAST(DATEPART(mm, T_attemperPlantVehicleMain.ComputeVehicleDate) AS varchar(50)) AS Date,
T_attemperPlantVehicleMain表名,ComputeVehicleDate列名
ComputeVehicleDate这个列数据库给的值是:“2001-01”这样的,但出来的结果却是“2001-1”,
现在我想将“2001-1” 变成 “2001-01”???
请问各位大侠怎么做?