{"id":84,"date":"2020-06-02T20:48:22","date_gmt":"2020-06-02T20:48:22","guid":{"rendered":"http:\/\/bahadirmeric.net\/bahadir\/?p=84"},"modified":"2020-06-02T20:48:22","modified_gmt":"2020-06-02T20:48:22","slug":"saniye-yi-saat-formatina-cevirmek","status":"publish","type":"post","link":"http:\/\/bahadirmeric.net\/bahadir\/2020\/06\/02\/saniye-yi-saat-formatina-cevirmek\/","title":{"rendered":"Saniye\u2019 yi Saat Format\u0131na \u00c7evirmek"},"content":{"rendered":"\n<p>Normalde SQL \u00fczerinde zaman format\u0131 d\u00f6n\u00fc\u015ft\u00fcr\u00fcc\u00fcler ve fonksiyonlar bu i\u015finizi temelde \u00e7\u00f6zecektir. Fakat bu fonksiyonlar saat dilimi 24\u2032 \u00fcn \u00fcst\u00fcne \u00e7\u0131kt\u0131\u011f\u0131 anda \u00e7evrimde hata yapmaktad\u0131r. \u0130\u015fte bunu \u00f6nlemek amac\u0131yla en temelde kendi fonksiyonunuza ihtiya\u00e7 duymaya ba\u015flars\u0131n\u0131z.<\/p>\n\n\n\n<p>Bu fonksiyonumuz da bu i\u015flemi yaparak sizlere saniyeden de\u011ferleri al\u0131p \u201c00:00:00\u201d format\u0131n da bir \u00e7\u0131kt\u0131 alman\u0131z\u0131 sa\u011flayacakt\u0131r. \u0130\u015fte kodumuz a\u015fa\u011f\u0131daki gibidir;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE FUNCTION &#x5B;dbo].&#x5B;fConvertTimeFormat]\n(\n       @duration INT\n)\nRETURNS NVARCHAR(20)\nAS\nBEGIN\n    DECLARE @Minute INT\n    DECLARE @Second INT\n    DECLARE @Hour INT\n    DECLARE @Rump INT\n    DECLARE @strTime NVARCHAR(20)\n    SET @Rump = @duration\n    SET @Minute = 0\n    SET @Hour = 0\n \n    --DAK\u0130KA HESAPLANIYOR\n    WHILE(@Rump&gt;59)\n    BEGIN\n    SET @Rump = @Rump - 60\n    SET @Minute = @Minute + 1\n    END\n    SET @Second = @Rump\n \n    --SAAT HESAPLANIYOR\n    SET @Rump = @Minute\n    WHILE(@Rump&gt;59)\n    BEGIN\n    SET @Rump = @Rump - 60\n    SET @Hour = @Hour + 1\n    END\n    SET @Minute = @Rump\n \n    --TIME FORMATI UYGULANIYOR\n    IF(@Hour &lt;=9)\n        SET @strTime = '0' + CAST(@Hour AS VARCHAR) + ':'\n    ELSE\n        SET @strTime = CAST(@Hour AS VARCHAR) + ':'\n \n    IF(@Minute&lt;=9)\n        SET @strTime = @strTime + '0' + CAST(@Minute AS VARCHAR) + ':'\n    ELSE\n        SET @strTime = @strTime + CAST(@Minute AS VARCHAR) + ':'\n \n    IF(@Second&lt;=9)\n        SET @strTime = @strTime + '0' + CAST(@Second AS VARCHAR)\n    ELSE\n        SET @strTime = @strTime + CAST(@Second AS VARCHAR)\n \n    RETURN @strTime\nEND\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Normalde SQL \u00fczerinde zaman format\u0131 d\u00f6n\u00fc\u015ft\u00fcr\u00fcc\u00fcler ve fonksiyonlar bu i\u015finizi temelde \u00e7\u00f6zecektir. Fakat bu fonksiyonlar saat dilimi 24\u2032 \u00fcn \u00fcst\u00fcne \u00e7\u0131kt\u0131\u011f\u0131 anda \u00e7evrimde hata yapmaktad\u0131r. \u0130\u015fte bunu \u00f6nlemek amac\u0131yla en temelde kendi fonksiyonunuza ihtiya\u00e7 duymaya ba\u015flars\u0131n\u0131z. Bu fonksiyonumuz da bu i\u015flemi yaparak sizlere saniyeden de\u011ferleri al\u0131p \u201c00:00:00\u201d format\u0131n da bir&#8230; <a class=\"continue-reading-link\" href=\"http:\/\/bahadirmeric.net\/bahadir\/2020\/06\/02\/saniye-yi-saat-formatina-cevirmek\/\"> Continue reading <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":10,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[8,2],"class_list":["post-84","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-ms-sql","tag-sql"],"_links":{"self":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/84","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/comments?post=84"}],"version-history":[{"count":1,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/84\/revisions"}],"predecessor-version":[{"id":85,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/84\/revisions\/85"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/media\/10"}],"wp:attachment":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/media?parent=84"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/categories?post=84"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/tags?post=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}