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
-- SELECT  DBO.LG_INTTODATE(190054657) 
--RESULT 2900-01-01 00:00:00.000