{"id":178,"date":"2022-05-20T22:53:28","date_gmt":"2022-05-20T19:53:28","guid":{"rendered":"http:\/\/www.cuneytbayrak.com\/?p=178"},"modified":"2025-02-20T22:54:01","modified_gmt":"2025-02-20T19:54:01","slug":"mssqlde-son-gunayyil-verilerini-getirme","status":"publish","type":"post","link":"http:\/\/www.cuneytbayrak.com\/?p=178","title":{"rendered":"MSSQL\u2019de Son \u2026\u2026.. (g\u00fcn,ay,y\u0131l) Verilerini Getirme"},"content":{"rendered":"<p>Son 3 g\u00fcn\u00fcn verilerini getirme;<\/p>\n<div class=\"wp-block-codemirror-blocks code-block\">\n<pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;material&quot;,&quot;lineNumbers&quot;:true,&quot;lineWrapping&quot;:false,&quot;styleActiveLine&quot;:false,&quot;readOnly&quot;:true,&quot;align&quot;:&quot;&quot;}\">where Tarih &gt;= DATEADD(DAY, -3, GETDATE())<\/pre>\n<\/div>\n<p>Son 3 ay\u0131n verilerini getirme;<\/p>\n<div class=\"wp-block-codemirror-blocks code-block \">\n<pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;material&quot;,&quot;lineNumbers&quot;:true,&quot;lineWrapping&quot;:false,&quot;styleActiveLine&quot;:false,&quot;readOnly&quot;:true,&quot;align&quot;:&quot;&quot;}\">where Tarih &gt;= DATEADD(MONTH, -3, GETDATE())<\/pre>\n<\/div>\n<p>Son 3 y\u0131l\u0131n verilerini getirme;<\/p>\n<div class=\"wp-block-codemirror-blocks code-block \">\n<pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;material&quot;,&quot;lineNumbers&quot;:true,&quot;lineWrapping&quot;:false,&quot;styleActiveLine&quot;:false,&quot;readOnly&quot;:true,&quot;align&quot;:&quot;&quot;}\">where Tarih &gt;= DATEADD(YEAR, -3, GETDATE())<\/pre>\n<\/div>\n<p>3 rakam\u0131 elbette ki sizin istedi\u011finiz s\u00fcreye g\u00f6re de\u011fi\u015fir.<\/p>\n<p>Kolay gele&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Son 3 g\u00fcn\u00fcn verilerini getirme; where Tarih &gt;= DATEADD(DAY, -3, GETDATE()) Son 3 ay\u0131n verilerini getirme; where Tarih &gt;= DATEADD(MONTH, -3, GETDATE()) Son 3 y\u0131l\u0131n verilerini getirme; where Tarih &gt;=&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"http:\/\/www.cuneytbayrak.com\/?p=178\">Devam\u0131n\u0131 Oku<span class=\"screen-reader-text\">MSSQL\u2019de Son \u2026\u2026.. (g\u00fcn,ay,y\u0131l) Verilerini Getirme<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":3,"footnotes":""},"categories":[7],"tags":[48],"class_list":["post-178","post","type-post","status-publish","format-standard","hentry","category-mssql","tag-getmssqllastdaymountyear","excerpt"],"_links":{"self":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=178"}],"version-history":[{"count":1,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/178\/revisions"}],"predecessor-version":[{"id":179,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/178\/revisions\/179"}],"wp:attachment":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=178"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}