{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"SQL ve SPL'de Tarih Aral\u0131klar\u0131n\u0131 Hesaplama","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"wYb24zeSLF\"><a href=\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-tarih-araliklarini-hesaplama\/\">SQL ve SPL&#8217;de Tarih Aral\u0131klar\u0131n\u0131 Hesaplama<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-tarih-araliklarini-hesaplama\/embed\/#?secret=wYb24zeSLF\" width=\"600\" height=\"338\" title=\"&#8220;SQL ve SPL&#8217;de Tarih Aral\u0131klar\u0131n\u0131 Hesaplama&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"wYb24zeSLF\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n<\/script>\n","description":"Veri analizi s\u00fcrecinde s\u0131kl\u0131kla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131z bir sorun, belirli bir tarih aral\u0131\u011f\u0131 i\u00e7indeki t\u00fcm y\u0131l\/aylar\u0131 tespit etmektir. Bu i\u015flem, SQL ve SPL (Splice) gibi farkl\u0131 veritaban\u0131 y\u00f6netim sistemlerinde farkl\u0131 y\u00f6ntemlerle ger\u00e7ekle\u015ftirilebilir. Bu makalede, her iki sistemde de bu i\u015flemin nas\u0131l yap\u0131ld\u0131\u011f\u0131n\u0131 detayl\u0131 olarak ele alaca\u011f\u0131z ve y\u00f6ntemleri kar\u015f\u0131la\u015ft\u0131raca\u011f\u0131z. \u00d6ncelikle, sorunun ne oldu\u011funu daha net anlamak i\u00e7in bir \u00f6rne\u011fe bakal\u0131m."}