2016

Logo veritabanında integer olarak tutulan tarih bilgisininin datetime’a çeviren fonksiyon.

CREATE FUNCTION fn_LogoDatetoSystemDate (@DEGER INT) RETURNS datetime AS BEGIN DECLARE @GUN VARCHAR(2), @AY VARCHAR(2), @YIL VARCHAR(4) DECLARE @SONUC datetime SELECT @GUN=CAST((CONVERT(INT,CONVERT(BINARY,@DEGER,2),0)-(CONVERT(INT,CONVERT(BINARY,@DEGER,2),0)/256*256)) AS VARCHAR(3)) SELECT @AY=CAST(((CONVERT(INT,CONVERT(BINARY,@DEGER,2),0)-(65536*(CONVERT(INT,CONVERT(BINARY,@DEGER,2),0)/65536)))-(CONVERT(INT,CONVERT(BINARY,@DEGER,2),0)-(CONVERT(INT,CONVERT(BINARY,@DEGER,2),0)/256*256)))/256 AS VARCHAR(3)) SELECT @YIL=CAST((CONVERT(INT,CONVERT(BINARY,@DEGER,2),0)/65536) AS…