SQLserver的函数

ALTER FUNCTION dbo.ConvertToDay
    (
        @InPutTime datetime
    )
RETURNS nvarchar(15)
AS
begin
        declare @year nvarchar(10)
        declare @month nvarchar(10)
        declare @day nvarchar(10)
        set @year = YEAR(@InPutTime)
        set @month = Month(@InPutTime)
        set @day = Day(@InPutTime)
        declare @Time nvarchar(15)
        set @Time = @year + '-' + @month + '-' + @day
    RETURN @Time
end

 

调用方法：

dbo.ConvertToDay(starttime);