Torna al Thread

ALTER FUNCTION [dbo].[DataToString] ( @Data datetime ) RETURNS varchar(20) AS BEGIN DECLARE @Appo varchar(20) SET @Appo = convert(varchar(20) ,@data, 120) SET @Appo = Substring(@Appo,1,4) + Substring(@Appo,6,2) + Substring(@Appo,9,2) + Substring(@Appo,12,2) + Substring(@Appo,15,2) + Substring(@Appo,18,2) -- Return the result of the function RETURN @Appo END
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5