1、写一个函数处理一下了 ALTER function F_Getdd(@Date DATETIME) returns CHAR(10) AS BEGIN DECLARE @Cc CHAR(10) SET @Cc= CONVERT(varchar(10), @Date,120) SET @Cc = (CAST(YEAR(@Cc) AS CHAR(4))+'-'+CAST(MONTH(@Cc) AS VARCHAR)+'-'+CAST(DAY(@Cc) AS VARCHAR)) RETURN @Cc END
2-select convert(varchar(10),cast('2004-5-1'as datetime),120)
ALTER function F_Getdd(@Date DATETIME)
returns CHAR(10)
AS
BEGIN
DECLARE @Cc CHAR(10)
SET @Cc= CONVERT(varchar(10), @Date,120)
SET @Cc = (CAST(YEAR(@Cc) AS CHAR(4))+'-'+CAST(MONTH(@Cc) AS VARCHAR)+'-'+CAST(DAY(@Cc) AS VARCHAR))
RETURN @Cc
END