{"id":1563,"date":"2015-04-27T13:37:57","date_gmt":"2015-04-27T10:37:57","guid":{"rendered":"http:\/\/www.ozgurguler.net\/blog\/?p=1563"},"modified":"2016-04-27T13:38:43","modified_gmt":"2016-04-27T10:38:43","slug":"sql-tarih-sorgulama-sql-yilin-ilk-gunu","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/sql-tarih-sorgulama-sql-yilin-ilk-gunu\/","title":{"rendered":"Sql Tarih Sorgulama , Sql Y\u0131l\u0131n ilk G\u00fcn\u00fc"},"content":{"rendered":"<pre>DECLARE @tarih DATETIME=GETDATE()\r\nSELECT 'Onceki Ay\u0131n Son Gunu' Aciklama,CONVERT(VARCHAR(10),<wbr \/>DATEADD(dd,-(DAY(@tarih)),@<wbr \/>tarih),112)  Tarih\r\nUNION ALL\r\nSELECT 'Ay\u0131n \u0130lk G\u00fcn\u00fc',CONVERT(VARCHAR(10),<wbr \/>DATEADD(dd,-(DAY(@tarih)-1),@<wbr \/>tarih),112) AS Date_Value\r\nUNION ALL\r\nSELECT 'Bugunun Tarihi',CONVERT(VARCHAR(10),@<wbr \/>tarih,112) AS Date_Value\r\nUNION ALL\r\nSELECT 'Ay\u0131n Son G\u00fcn\u00fc',CONVERT(VARCHAR(10),<wbr \/>DATEADD(dd,-(DAY(DATEADD(mm,1,<wbr \/>@tarih))),DATEADD(mm,1,@tarih)<wbr \/>),112) \r\nUNION ALL\r\nSELECT 'Sonraki Ay\u0131n \u0130lk G\u00fcn\u00fc',CONVERT(VARCHAR(10),<wbr \/>DATEADD(dd,-(DAY(DATEADD(mm,1,<wbr \/>@tarih))-1),DATEADD(mm,1,@<wbr \/>tarih)),112) \r\nUNION ALL\r\nSELECT 'Haftan\u0131n \u0130lk G\u00fcn\u00fc', DATEADD(ww, DATEDIFF(ww,0,GETDATE()), 0)\r\nUNION ALL\r\nSELECT 'Sonraki Haftan\u0131n \u0130lk G\u00fcn\u00fc', DATEADD(ww, DATEDIFF(ww,0,GETDATE())+1, 0)\r\nUNION ALL\r\nSELECT 'Y\u0131l\u0131n \u0130lk G\u00fcn\u00fc',DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)\r\nUNION ALL\r\nSELECT 'Y\u0131l\u0131n Son G\u00fcn\u00fc',DATEADD(dd,-1,DATEADD(<wbr \/>yy,0,DATEADD(yy,DATEDIFF(yy,0,<wbr \/>getdate())+1,0)))<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>DECLARE @tarih DATETIME=GETDATE() SELECT &#8216;Onceki Ay\u0131n Son Gunu&#8217; Aciklama,CONVERT(VARCHAR(10),DATEADD(dd,-(DAY(@tarih)),@tarih),112) Tarih UNION ALL SELECT &#8216;Ay\u0131n \u0130lk G\u00fcn\u00fc&#8217;,CONVERT(VARCHAR(10),DATEADD(dd,-(DAY(@tarih)-1),@tarih),112) AS Date_Value UNION ALL SELECT &#8216;Bugunun Tarihi&#8217;,CONVERT(VARCHAR(10),@tarih,112) AS Date_Value UNION ALL SELECT &#8216;Ay\u0131n Son G\u00fcn\u00fc&#8217;,CONVERT(VARCHAR(10),DATEADD(dd,-(DAY(DATEADD(mm,1,@tarih))),DATEADD(mm,1,@tarih)),112) UNION ALL SELECT &#8216;Sonraki Ay\u0131n \u0130lk G\u00fcn\u00fc&#8217;,CONVERT(VARCHAR(10),DATEADD(dd,-(DAY(DATEADD(mm,1,@tarih))-1),DATEADD(mm,1,@tarih)),112) UNION ALL SELECT &#8216;Haftan\u0131n \u0130lk G\u00fcn\u00fc&#8217;, DATEADD(ww, DATEDIFF(ww,0,GETDATE()), 0) UNION ALL SELECT &#8216;Sonraki Haftan\u0131n \u0130lk G\u00fcn\u00fc&#8217;, DATEADD(ww, [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-1563","post","type-post","status-publish","format-standard","hentry","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1563","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=1563"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1563\/revisions"}],"predecessor-version":[{"id":1564,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1563\/revisions\/1564"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=1563"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=1563"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=1563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}