{"id":2872,"date":"2018-11-26T11:42:19","date_gmt":"2018-11-26T08:42:19","guid":{"rendered":"https:\/\/www.ozgurguler.net\/blog\/?p=2872"},"modified":"2018-11-26T11:42:19","modified_gmt":"2018-11-26T08:42:19","slug":"sql-server-gun-ve-ay-adlari","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/sql-server-gun-ve-ay-adlari\/","title":{"rendered":"SQL SERVER G\u00fcn ve Ay adlar\u0131"},"content":{"rendered":"<h3>SQL SERVER G\u00fcn ve Ay\u00a0adlar\u0131<\/h3>\n<p>Projenizde g\u00fcn ve ay adlar\u0131n\u0131n T\u00fcrk\u00e7e olarak g\u00f6r\u00fcnt\u00fclenmesini istiyorsak \u00f6nce SQL SERVER\u2019da dil se\u00e7ene\u011fini t\u00fcrk\u00e7e yap\u0131p sonra gerekli query\u2019le diledi\u011fimiz tarihe ait g\u00fcn ya da ay ad\u0131n\u0131 g\u00f6r\u00fcnt\u00fcleyebiliriz.<\/p>\n<p>G\u00fcn i\u00e7in:<\/p>\n<p>SET language turkish<br \/>\nSELECT datename(dw,GETDATE()) as day<\/p>\n<p>Ay i\u00e7in:<\/p>\n<p>SET language turkish<br \/>\nSELECT datename(month,GETDATE()) as month<\/p>\n<p>Hepsi bu kadar. Ayr\u0131ca GETDATE() yani o g\u00fcne ait tarihi getirmek d\u0131\u015f\u0131nda do\u011fru formatla birlikte herhangi bir tarihe ait g\u00fcn ya da ay adlar\u0131n\u0131da g\u00f6r\u00fcnt\u00fcleyebilirsiniz, diyelim ki 27.11.1981 tarihine ait g\u00fcn\u00fc getirmek istersek:<\/p>\n<p>SET language turkish<br \/>\nSELECT datename(dw,&#8217;27.11.1981&#8242;) as day<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL SERVER G\u00fcn ve Ay\u00a0adlar\u0131 Projenizde g\u00fcn ve ay adlar\u0131n\u0131n T\u00fcrk\u00e7e olarak g\u00f6r\u00fcnt\u00fclenmesini istiyorsak \u00f6nce SQL SERVER\u2019da dil se\u00e7ene\u011fini t\u00fcrk\u00e7e yap\u0131p sonra gerekli query\u2019le diledi\u011fimiz tarihe ait g\u00fcn ya da ay ad\u0131n\u0131 g\u00f6r\u00fcnt\u00fcleyebiliriz. G\u00fcn i\u00e7in: SET language turkish SELECT datename(dw,GETDATE()) as day Ay i\u00e7in: SET language turkish SELECT datename(month,GETDATE()) as month Hepsi bu kadar. Ayr\u0131ca [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":2722,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-2872","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2872","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=2872"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2872\/revisions"}],"predecessor-version":[{"id":2873,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2872\/revisions\/2873"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media\/2722"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=2872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=2872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=2872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}