{"id":1547,"date":"2016-01-27T13:02:58","date_gmt":"2016-01-27T11:02:58","guid":{"rendered":"http:\/\/www.ozgurguler.net\/blog\/?p=1547"},"modified":"2016-04-27T13:03:41","modified_gmt":"2016-04-27T10:03:41","slug":"logo-veritabaninda-integer-olarak-tutulan-tarih-bilgisininin-datetimea-ceviren-fonksiyon","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/logo-veritabaninda-integer-olarak-tutulan-tarih-bilgisininin-datetimea-ceviren-fonksiyon\/","title":{"rendered":"Logo veritaban\u0131nda integer olarak tutulan tarih bilgisininin datetime’a \u00e7eviren fonksiyon."},"content":{"rendered":"

CREATE<\/span> FUNCTION<\/span> fn_LogoDatetoSystemDate (@DEGER INT<\/span>) <\/span>
\nRETURNS<\/span> datetime<\/span>
\nAS<\/span>
\nBEGIN<\/span>
\nDECLARE @GUN VARCHAR<\/span>(2<\/span>), @AY VARCHAR<\/span>(2<\/span>), @YIL VARCHAR<\/span>(4<\/span>)<\/span><\/p>\n

DECLARE<\/span> @SONUC datetime<\/span>
\nSELECT<\/span>
\n@GUN=CAST<\/span>((CONVERT<\/span>(INT<\/span>,CONVERT<\/span>(BINARY<\/span>,@DEGER,2<\/span>),0<\/span>)-(CONVERT<\/span>(INT<\/span>,CONVERT<\/span>(BINARY<\/span>,@DEGER,2<\/span>),0<\/span>)\/256<\/span>*256<\/span>)) AS<\/span> VARCHAR<\/span>(3<\/span>))<\/span>
\nSELECT<\/span><\/span>
\n@AY=CAST<\/span>(((CONVERT<\/span>(INT<\/span>,CONVERT<\/span>(BINARY<\/span>,@DEGER,2<\/span>),0<\/span>)-(65536<\/span>*(CONVERT<\/span>(INT<\/span>,CONVERT<\/span>(BINARY<\/span>,@DEGER,2<\/span>),0<\/span>)\/65536<\/span>)))-(CONVERT<\/span>(INT<\/span>,CONVERT<\/span>(BINARY<\/span>,@DEGER,2<\/span>),0<\/span>)-(CONVERT<\/span>(INT<\/span>,CONVERT<\/span>(BINARY<\/span>,@DEGER,2<\/span>),0<\/span>)\/256<\/span>*256<\/span>)))\/256<\/span> AS<\/span> VARCHAR<\/span>(3<\/span>))<\/span>
\nSELECT<\/span><\/span>
\n@YIL=CAST<\/span>((CONVERT<\/span>(INT<\/span>,CONVERT<\/span>(BINARY<\/span>,@DEGER,2<\/span>),0<\/span>)\/65536<\/span>) AS<\/span> VARCHAR<\/span>(6<\/span>))<\/span>
\nSET<\/span> @GUN=CASE<\/span> WHEN<\/span> LEN<\/span>(@GUN)<2<\/span> THEN<\/span> ‘0’<\/span>+@GUN ELSE<\/span> @GUN END<\/span>
\nSET @AY=CASE<\/span> WHEN<\/span> LEN<\/span>(@AY)<2<\/span> THEN<\/span> ‘0’<\/span>+@AY ELSE<\/span> @AY END<\/span>
\nSONUC:<\/span>
\nIF<\/span> @DEGER<>0<\/span><\/span>
\nBEGIN<\/span>
\nSET @SONUC=CONVERT<\/span>(DATETIME, @YIL + ‘-‘<\/span> + @AY + ‘-‘<\/span> + @GUN + ‘ 00:00:00’<\/span>, 102<\/span>)<\/span>
\nEND<\/span>
\nIF @DEGER=0<\/span><\/span>
\nSET<\/span> @SONUC= NULL<\/span>
\nRETURN @SONUC<\/span>
\nEND<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

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 VARCHAR(6)) SET @GUN=CASE WHEN LEN(@GUN)<2 THEN ‘0’+@GUN ELSE @GUN END SET @AY=CASE WHEN LEN(@AY)<2 THEN ‘0’+@AY ELSE @AY END SONUC: IF @DEGER<>0 BEGIN SET @SONUC=CONVERT(DATETIME, […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,10],"tags":[],"class_list":["post-1547","post","type-post","status-publish","format-standard","hentry","category-logorapor","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1547","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=1547"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1547\/revisions"}],"predecessor-version":[{"id":1548,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1547\/revisions\/1548"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=1547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=1547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=1547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}