{"id":54,"date":"2020-06-02T20:21:35","date_gmt":"2020-06-02T20:21:35","guid":{"rendered":"http:\/\/bahadirmeric.net\/bahadir\/?p=54"},"modified":"2020-06-02T20:21:35","modified_gmt":"2020-06-02T20:21:35","slug":"ms-sql-de-gun-adlari","status":"publish","type":"post","link":"http:\/\/bahadirmeric.net\/bahadir\/2020\/06\/02\/ms-sql-de-gun-adlari\/","title":{"rendered":"MS SQL\u2019 de G\u00fcn Adlar\u0131"},"content":{"rendered":"\n

Arada s\u0131rada ihtiya\u00e7 duydu\u011fum bir \u015fey asl\u0131nda sql taraf\u0131nda bir tarihin hangi g\u00fcne denk geldi\u011fini bulmak. Hatta bunun i\u00e7in kendi fonksiyonumu bile yazm\u0131\u015ft\u0131m \ud83d\ude42 Fakat Sql\u2019in geli\u015fmesi ve ihtiya\u00e7lar\u0131n daha net ortaya \u00e7\u0131k\u0131yor olmas\u0131yla birlikte bir komutla verdi\u011finiz tarihin hangi g\u00fcne denk geldi\u011fini bulabiliyorsunuz. \u00dcstelik T\u00fcrk\u00e7e olarak da \u00e7\u0131kt\u0131 alabiliyorsunuz.<\/p>\n\n\n\n

Bunu nas\u0131l yapt\u0131\u011f\u0131m\u0131za gelince a\u015fa\u011f\u0131daki komutu kullan\u0131rsan\u0131z ve server dil ayarlar\u0131n\u0131z \u0130ngilizce ise bak\u0131n \u00e7\u0131kt\u0131 ne olacak?<\/p>\n\n\n

\nSELECT datename(dw,GETDATE()) as day\n<\/pre><\/div>\n\n\n
T\u00fcrk\u00e7e \u00e7\u0131kt\u0131 almak i\u00e7inde \u015fu \u015fekilde kullanaca\u011f\u0131z;<\/p>\n\n\n
\nSET language turkish\nSELECT datename(dw,GETDATE()) as day\n<\/pre><\/div>\n\n\n
Ayr\u0131ca ay ismi \u00f6\u011frenmek istiyorsak da;<\/p>\n\n\n
\nSET language turkish\nSELECT datename(month,GETDATE()) as month\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
Arada s\u0131rada ihtiya\u00e7 duydu\u011fum bir \u015fey asl\u0131nda sql taraf\u0131nda bir tarihin hangi g\u00fcne denk geldi\u011fini bulmak. Hatta bunun i\u00e7in kendi fonksiyonumu bile yazm\u0131\u015ft\u0131m \ud83d\ude42 Fakat Sql\u2019in geli\u015fmesi ve ihtiya\u00e7lar\u0131n daha net ortaya \u00e7\u0131k\u0131yor olmas\u0131yla birlikte bir komutla verdi\u011finiz tarihin hangi g\u00fcne denk geldi\u011fini bulabiliyorsunuz. \u00dcstelik T\u00fcrk\u00e7e olarak da \u00e7\u0131kt\u0131 alabiliyorsunuz….  Continue reading → <\/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-54","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\/54","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=54"}],"version-history":[{"count":1,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/54\/revisions"}],"predecessor-version":[{"id":55,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/54\/revisions\/55"}],"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=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/categories?post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/tags?post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}