{"id":1549,"date":"2016-01-27T13:04:06","date_gmt":"2016-01-27T11:04:06","guid":{"rendered":"http:\/\/www.ozgurguler.net\/blog\/?p=1549"},"modified":"2016-04-27T13:12:28","modified_gmt":"2016-04-27T10:12:28","slug":"logo-icin-tarih-bilgisinini-datetimea-integer-olarak-ceviren-fonksiyon","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/logo-icin-tarih-bilgisinini-datetimea-integer-olarak-ceviren-fonksiyon\/","title":{"rendered":"Logo i\u00e7in tarih bilgisinini datetime’a integer olarak \u00e7eviren fonksiyon."},"content":{"rendered":"

CREATE<\/span> FUNCTION<\/span> fn_LogoTimetoSystemTime (@GELENDEGER INT<\/span>)<\/span>
\nRETURNS<\/span> VARCHAR<\/span>(8<\/span>)<\/span>
\nAS<\/span>
\nBEGIN<\/span>
\nDECLARE @SAAT VARCHAR<\/span>(2<\/span>), @DAKIKA VARCHAR<\/span>(2<\/span>), @SANIYE VARCHAR<\/span>(2<\/span>), @SONUC VARCHAR<\/span>(8<\/span>)<\/span>
\nSELECT<\/span><\/span>
\n@SAAT=RTRIM<\/span>(CONVERT<\/span>(char<\/span>(20<\/span>), ROUND<\/span>(@GELENDEGER \/ 16777216<\/span>, 2<\/span>))),<\/span>
\n@DAKIKA=RTRIM<\/span>(CONVERT<\/span>(char<\/span>(20<\/span>), ROUND<\/span>((@GELENDEGER – ROUND<\/span>(@GELENDEGER \/ 16777216<\/span>, 2<\/span>) * 16777216<\/span>)\/ 65536<\/span>, 2<\/span>))),<\/span>
\n@SANIYE=RTRIM<\/span>(CONVERT<\/span>(char<\/span>(20<\/span>), ROUND<\/span>((@GELENDEGER – ROUND<\/span>(@GELENDEGER \/ 16777216<\/span>, 2<\/span>) * 16777216<\/span> – ROUND<\/span>((@GELENDEGER – ROUND<\/span>(@GELENDEGER \/ 16777216<\/span>, 2<\/span>) * 16777216<\/span>) \/ 65536<\/span>, 2<\/span>) * 65536<\/span>) \/ 256<\/span>, 2<\/span>)))<\/span>
\nSET<\/span> @SAAT=CASE<\/span> WHEN<\/span> LEN<\/span>(@SAAT)=1<\/span> THEN<\/span> ‘0’<\/span>+@SAAT ELSE<\/span> @SAAT END<\/span> <\/span>
\nSET<\/span> @DAKIKA=CASE<\/span> WHEN<\/span> LEN<\/span>(@DAKIKA)=1<\/span> THEN<\/span> ‘0’<\/span>+@DAKIKA ELSE<\/span> @DAKIKA END<\/span> <\/span>
\nSET<\/span> @SANIYE=CASE<\/span> WHEN<\/span> LEN<\/span>(@SANIYE)=1<\/span> THEN<\/span> ‘0’<\/span>+@SANIYE ELSE<\/span> @SANIYE END<\/span>
\nSET @SONUC= @SAAT + ‘:’<\/span> +@DAKIKA + ‘:’<\/span> + @SANIYE<\/span>
\nRETURN @SONUC<\/span>
\nEND <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

CREATE FUNCTION fn_LogoTimetoSystemTime (@GELENDEGER INT) RETURNS VARCHAR(8) AS BEGIN DECLARE @SAAT VARCHAR(2), @DAKIKA VARCHAR(2), @SANIYE VARCHAR(2), @SONUC VARCHAR(8) SELECT @SAAT=RTRIM(CONVERT(char(20), ROUND(@GELENDEGER \/ 16777216, 2))), @DAKIKA=RTRIM(CONVERT(char(20), ROUND((@GELENDEGER – ROUND(@GELENDEGER \/ 16777216, 2) * 16777216)\/ 65536, 2))), @SANIYE=RTRIM(CONVERT(char(20), ROUND((@GELENDEGER – ROUND(@GELENDEGER \/ 16777216, 2) * 16777216 – ROUND((@GELENDEGER – ROUND(@GELENDEGER \/ 16777216, 2) * 16777216) \/ 65536, […]<\/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-1549","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\/1549","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=1549"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1549\/revisions"}],"predecessor-version":[{"id":1550,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1549\/revisions\/1550"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=1549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=1549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=1549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}