Logo LG_INTTODATE Sql Fonksiyonu

Merhabalar Logoya dışarından sql ile kayıt atarken ihtiyaç olan LG_INTTODATE sql fonksiyonu.

CREATE FUNCTION [dbo].[LG_INTTODATE](@LDATE INT)
       RETURNS DATETIME
AS
BEGIN
 DECLARE @DATE    DATETIME,
         @DD      INT,
         @MM      INT,
         @YYYY    INT,
         @DATESTR VARCHAR(12)
 SELECT @DD   = ((@LDATE%65536)/256)
 SELECT @MM   = (@LDATE%65536)%256
 SELECT @YYYY = (@LDATE/65536)
 SELECT @DATESTR = CAST(@DD AS VARCHAR(2))+'-'+
                   CAST(@MM AS VARCHAR(2))+'-'+
                   CAST(@YYYY AS VARCHAR(4))
 SELECT @DATE = CONVERT(DATETIME,@DATESTR,102)
 RETURN(@DATE)
END