{"id":25604,"date":"2025-07-09T12:15:26","date_gmt":"2025-07-09T09:15:26","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/"},"modified":"2025-07-09T12:15:26","modified_gmt":"2025-07-09T09:15:26","slug":"postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/","title":{"rendered":"PostgreSQL: Hafta Numaras\u0131ndan Hafta Ba\u015flang\u0131\u00e7 Tarihini Alma"},"content":{"rendered":"<p># PostgreSQL&#8217;de Hafta Numaras\u0131ndan Hafta Ba\u015flang\u0131\u00e7 Tarihini Bulma<\/p>\n<p>PostgreSQL veritaban\u0131n\u0131zda haftal\u0131k raporlama yap\u0131yorsunuz ve haftan\u0131n numaras\u0131ndan o haftan\u0131n ba\u015flang\u0131\u00e7 tarihini h\u0131zl\u0131ca bulman\u0131z gerekiyor.  Bu, bir\u00e7ok i\u015f zekas\u0131 uygulamas\u0131nda, \u00f6zellikle tarihsel verilerin analizinde s\u0131k kar\u015f\u0131la\u015f\u0131lan bir durumdur. Bu makalede, PostgreSQL kullanarak hafta numaras\u0131ndan hafta ba\u015flang\u0131\u00e7 tarihini nas\u0131l hesaplayaca\u011f\u0131n\u0131z\u0131 ad\u0131m ad\u0131m, farkl\u0131 seviyelerde ele alaca\u011f\u0131z.  Ba\u015flang\u0131\u00e7 seviyesinden ileri seviye tekniklere kadar uzanan bir yol haritas\u0131 sunaca\u011f\u0131z, ger\u00e7ek d\u00fcnya senaryolar\u0131n\u0131 inceleyecek ve performans optimizasyonuna odaklanaca\u011f\u0131z.<\/p>\n<p><strong>\u00d6\u011frenme Yol Haritas\u0131<\/strong><\/p>\n<p><strong>Yeni Ba\u015flayan:<\/strong> (Ad\u0131m ad\u0131m a\u00e7\u0131klama, Basit kod \u00f6rne\u011fi) \u2192 <strong>Orta:<\/strong> (Ger\u00e7ek hayat \u00f6rne\u011fi, Optimizasyon ipu\u00e7lar\u0131) \u2192 <strong>\u0130leri D\u00fczey:<\/strong> (Performans analizi, Edge caseler)<\/p>\n<p><strong>Temel Kavramlar: PostgreSQL&#8217;de Tarih ve Zaman Fonksiyonlar\u0131<\/strong><\/p>\n<p>PostgreSQL&#8217;in g\u00fc\u00e7l\u00fc tarih ve zaman fonksiyonlar\u0131, bu g\u00f6revi kolayla\u015ft\u0131r\u0131r.  \u00d6ncelikle,  <code class=\"language-\">date_trunc()<\/code>, <code class=\"language-\">extract()<\/code>, <code class=\"language-\">make_date()<\/code> ve <code class=\"language-\">to_char()<\/code> fonksiyonlar\u0131n\u0131 anlamak \u00f6nemlidir.<\/p>\n<p>* <strong><code class=\"language-\">date_trunc('week', tarih)<\/code>:<\/strong>  Belirtilen tarihi, haftan\u0131n ba\u015flang\u0131\u00e7 tarihine yuvarlar.  Hafta ba\u015flang\u0131c\u0131n\u0131n hangi g\u00fcn oldu\u011fu, PostgreSQL&#8217;in <code class=\"language-\">datestyle<\/code> ayar\u0131na ba\u011fl\u0131d\u0131r.  Varsay\u0131lan olarak genellikle Pazartesi&#8217;dir, ancak bu ayar de\u011fi\u015ftirilebilir.<\/p>\n<p>* <strong><code class=\"language-\">extract(field FROM tarih)<\/code>:<\/strong>  Tarihten belirli bir alan\u0131 (y\u0131l, ay, g\u00fcn, hafta numaras\u0131 vb.)  \u00e7\u0131kar\u0131r. Bizim i\u00e7in \u00f6nemli olan <code class=\"language-\">extract(week FROM tarih)<\/code> ve <code class=\"language-\">extract(year FROM tarih)<\/code> fonksiyonlar\u0131 olacakt\u0131r.<\/p>\n<p>* <strong><code class=\"language-\">make_date(y\u0131l, ay, g\u00fcn)<\/code>:<\/strong>  Y\u0131l, ay ve g\u00fcn de\u011ferlerinden bir tarih olu\u015fturur.<\/p>\n<p>* <strong><code class=\"language-\">to_char(tarih, format_kodlar\u0131)<\/code>:<\/strong> Tarihi belirtilen formata g\u00f6re bir metin dizesine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.  \u00d6rne\u011fin, <code class=\"language-\">to_char(tarih, 'YYYY-MM-DD')<\/code> tarihi &#8220;YYYY-MM-DD&#8221; format\u0131nda bir dize olarak d\u00f6nd\u00fcr\u00fcr.<\/p>\n<p><strong>PostgreSQL&#8217;de Hafta Ba\u015flang\u0131\u00e7 Tarihini Hesaplama: Ad\u0131m Ad\u0131m Uygulama<\/strong><\/p>\n<p>\u015eimdi, hafta numaras\u0131 ve y\u0131l\u0131 bilerek hafta ba\u015flang\u0131\u00e7 tarihini hesaplayal\u0131m.  \u00d6ncelikle, basit bir \u00f6rnek ile ba\u015flayaca\u011f\u0131z.<\/p>\n<p><strong>\u00d6rnek:<\/strong> 2024 y\u0131l\u0131n\u0131n 35. haftas\u0131n\u0131n ba\u015flang\u0131\u00e7 tarihini bulal\u0131m.<\/p>\n<pre class=\"language-sql\"><code>SELECT date_trunc('week', make_date(2024, 1, 1) + interval '34 weeks');<\/code><\/pre>\n<p>Bu kod, 2024 y\u0131l\u0131n\u0131n ilk g\u00fcn\u00fcnden ba\u015flayarak 34 hafta ileri gider (\u00e7\u00fcnk\u00fc hafta numaralar\u0131 1&#8217;den ba\u015flar) ve daha sonra <code class=\"language-\">date_trunc()<\/code> fonksiyonu ile haftan\u0131n ba\u015flang\u0131\u00e7 tarihine yuvarlar.  Bu y\u00f6ntem basit ve anla\u015f\u0131l\u0131r olsa da, daha geli\u015fmi\u015f senaryolarda yetersiz kalabilir.<\/p>\n<p><strong>Ger\u00e7ek Hayatta Hafta Ba\u015flang\u0131\u00e7 Tarihini Hesaplama: Daha Geli\u015fmi\u015f Bir Yakla\u015f\u0131m<\/strong><\/p>\n<p>Yukar\u0131daki y\u00f6ntem, y\u0131l\u0131n ba\u015flang\u0131\u00e7 tarihini referans alarak \u00e7al\u0131\u015f\u0131r. Ancak, farkl\u0131 bir hafta ba\u015flang\u0131\u00e7 g\u00fcn\u00fc kullan\u0131yorsan\u0131z veya daha karma\u015f\u0131k sorgular\u0131n\u0131z varsa, daha robust bir yakla\u015f\u0131m kullanman\u0131z gerekir.  \u00d6rne\u011fin, bir \u015firketin mali y\u0131l\u0131 Ocak yerine Temmuz ay\u0131nda ba\u015fl\u0131yorsa, bu y\u00f6ntemi do\u011frudan kullanamazs\u0131n\u0131z.<\/p>\n<p>A\u015fa\u011f\u0131daki fonksiyon, y\u0131l ve hafta numaras\u0131n\u0131 girdi olarak al\u0131r ve haftan\u0131n ba\u015flang\u0131\u00e7 tarihini d\u00f6nd\u00fcr\u00fcr.  Bu fonksiyon, haftan\u0131n ba\u015flang\u0131\u00e7 g\u00fcn\u00fcn\u00fc de parametre olarak alarak daha fazla esneklik sa\u011flar.<\/p>\n<pre class=\"language-sql\"><code>CREATE OR REPLACE FUNCTION get_week_start_date(year INT, week_number INT, week_start_day TEXT DEFAULT 'monday')\nRETURNS DATE AS $$\nDECLARE\n  first_day_of_year DATE;\n  first_week_day TEXT;\nBEGIN\n  first_day_of_year := make_date(year, 1, 1);\n  first_week_day := to_char(first_day_of_year, 'Day');\n\n  -- \u0130lk haftan\u0131n ba\u015flang\u0131\u00e7 g\u00fcn\u00fcn\u00fc hesapla\n  CASE\n    WHEN lower(week_start_day) = 'monday' THEN\n      IF lower(first_week_day) = 'monday' THEN\n        RETURN first_day_of_year + interval '(week_number - 1) weeks';\n      ELSE\n        RETURN first_day_of_year + interval '((week_number - 1) weeks + (7 - (EXTRACT(DOW FROM first_day_of_year)::INT))) days';\n      END IF;\n    WHEN lower(week_start_day) = 'sunday' THEN\n      -- Sunday case... (Benzer mant\u0131kla Sunday i\u00e7in hesaplama yap\u0131labilir)\n    ELSE\n      RAISE EXCEPTION 'Ge\u00e7ersiz hafta ba\u015flang\u0131\u00e7 g\u00fcn\u00fc: %', week_start_day;\n  END CASE;\nEND;\n$$ LANGUAGE plpgsql;\n\n-- \u00d6rnek kullan\u0131m: 2024 y\u0131l\u0131n\u0131n 35. haftas\u0131n\u0131n Pazartesi ba\u015flang\u0131\u00e7l\u0131 tarihini bulma\nSELECT get_week_start_date(2024, 35);\n\n-- \u00d6rnek kullan\u0131m: 2024 y\u0131l\u0131n\u0131n 35. haftas\u0131n\u0131n Pazar ba\u015flang\u0131\u00e7l\u0131 tarihini bulma (Pazar i\u00e7in case eklendikten sonra \u00e7al\u0131\u015facakt\u0131r)\nSELECT get_week_start_date(2024, 35, 'sunday');<\/code><\/pre>\n<p>Bu fonksiyon, daha sa\u011flam ve \u00f6zelle\u015ftirilebilir bir \u00e7\u00f6z\u00fcm sunar.<\/p>\n<p><strong>Performans Optimizasyonu ve \u0130pu\u00e7lar\u0131<\/strong><\/p>\n<p>B\u00fcy\u00fck veri k\u00fcmeleri \u00fczerinde \u00e7al\u0131\u015f\u0131rken, performans optimizasyonu \u00e7ok \u00f6nemlidir.  A\u015fa\u011f\u0131daki ipu\u00e7lar\u0131, sorgular\u0131n\u0131z\u0131n h\u0131z\u0131n\u0131 art\u0131rman\u0131za yard\u0131mc\u0131 olacakt\u0131r:<\/p>\n<p>* <strong>\u0130ndexler:<\/strong> <code class=\"language-\">year<\/code> ve <code class=\"language-\">week_number<\/code> s\u00fctunlar\u0131na indeks ekleyin.  Bu, veritaban\u0131n\u0131n ilgili sat\u0131rlar\u0131 daha h\u0131zl\u0131 bulmas\u0131n\u0131 sa\u011flar.<\/p>\n<p>* <strong>Fonksiyonlar\u0131n Optimizasyonu:<\/strong>  Yukar\u0131daki fonksiyonda, gereksiz hesaplamalar yapmaktan ka\u00e7\u0131nmak i\u00e7in kodunuzu optimize edebilirsiniz.  \u00d6rne\u011fin, <code class=\"language-\">CASE<\/code> ifadelerini daha verimli bir \u015fekilde d\u00fczenleyebilirsiniz.<\/p>\n<p>* <strong>Materialized Views:<\/strong>  E\u011fer ayn\u0131 sorguyu s\u0131k s\u0131k \u00e7al\u0131\u015ft\u0131r\u0131yorsan\u0131z, bir *materialized view* olu\u015fturmay\u0131 d\u00fc\u015f\u00fcnebilirsiniz.  Bu, \u00f6nceden hesaplanm\u0131\u015f sonu\u00e7lar\u0131 saklayarak sorgular\u0131n h\u0131z\u0131n\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131r\u0131r.<\/p>\n<p><strong>\u0130leri D\u00fczey Konular: Edge Case&#8217;ler ve Performans Analizi<\/strong><\/p>\n<p>Hafta numaras\u0131 hesaplamalar\u0131nda baz\u0131 \u00f6zel durumlar (edge case&#8217;ler) dikkate al\u0131nmal\u0131d\u0131r. \u00d6rne\u011fin, y\u0131l\u0131n ba\u015flang\u0131\u00e7 haftas\u0131 k\u0131smen \u00f6nceki y\u0131la ait olabilir veya y\u0131l\u0131n son haftas\u0131 k\u0131smen sonraki y\u0131la ait olabilir.  Bu durumlar\u0131 do\u011fru bir \u015fekilde ele almak i\u00e7in, hafta numaras\u0131 hesaplamas\u0131n\u0131n nas\u0131l tan\u0131mland\u0131\u011f\u0131n\u0131 (ISO 8601 gibi standartlar) ve veritaban\u0131n\u0131z\u0131n tarih ve zaman ayarlar\u0131n\u0131 dikkatlice incelemelisiniz.<\/p>\n<p>Performans analizi i\u00e7in, <code class=\"language-\">EXPLAIN ANALYZE<\/code> komutunu kullanarak sorgular\u0131n\u0131z\u0131n y\u00fcr\u00fctme plan\u0131n\u0131 inceleyebilir ve performans darbo\u011fazlar\u0131n\u0131 belirleyebilirsiniz.  Bu, sorgular\u0131n\u0131z\u0131 daha h\u0131zl\u0131 hale getirmek i\u00e7in gereken optimizasyonlar\u0131 belirlemenize yard\u0131mc\u0131 olur.<\/p>\n<p><strong>Ger\u00e7ek D\u00fcnya Senaryolar\u0131: Vaka Analizleri<\/strong><\/p>\n<p><strong>Vaka 1:<\/strong> E-ticaret sitesi sipari\u015f verilerini haftal\u0131k olarak analiz etmek istiyor.  Her hafta i\u00e7in toplam sipari\u015f say\u0131s\u0131n\u0131 ve toplam sat\u0131\u015f gelirini hesaplamak i\u00e7in <code class=\"language-\">get_week_start_date()<\/code> fonksiyonunu kullanabilirler.<\/p>\n<p><strong>Vaka 2:<\/strong> Bir pazarlama \u015firketi, haftal\u0131k kampanya performans\u0131n\u0131 izlemek istiyor.  Her hafta i\u00e7in kampanya etkile\u015fimlerini ve d\u00f6n\u00fc\u015f\u00fcm oranlar\u0131n\u0131 analiz etmek i\u00e7in <code class=\"language-\">get_week_start_date()<\/code> fonksiyonunu kullanabilirler.<\/p>\n<p><strong>Sonu\u00e7<\/strong><\/p>\n<p>PostgreSQL&#8217;de hafta numaras\u0131ndan hafta ba\u015flang\u0131\u00e7 tarihini bulmak i\u00e7in \u00e7e\u015fitli y\u00f6ntemler vard\u0131r.  Basit y\u00f6ntemler, k\u00fc\u00e7\u00fck veri k\u00fcmeleri i\u00e7in yeterli olabilirken, daha b\u00fcy\u00fck ve karma\u015f\u0131k veri k\u00fcmeleri i\u00e7in daha geli\u015fmi\u015f ve optimize edilmi\u015f yakla\u015f\u0131mlar gereklidir.  Bu makalede sundu\u011fumuz ad\u0131m ad\u0131m k\u0131lavuz, ger\u00e7ek d\u00fcnya senaryolar\u0131 ve performans optimizasyon ipu\u00e7lar\u0131 ile, PostgreSQL&#8217;de tarih ve zaman i\u015flemlerine daha derinlemesine inmenize yard\u0131mc\u0131 olacakt\u0131r.  [fatihsoysal.com](https:\/\/fatihsoysal.com) adresinden daha fazla PostgreSQL e\u011fitimine ula\u015fabilirsiniz.<\/p>\n<p><strong>S\u0131k\u00e7a Sorulan Sorular (SSS)<\/strong><\/p>\n<p>1. <strong>Hafta ba\u015flang\u0131\u00e7 g\u00fcn\u00fc nas\u0131l de\u011fi\u015ftirilir?<\/strong>  <code class=\"language-\">date_trunc('week', tarih)<\/code> fonksiyonunun davran\u0131\u015f\u0131, PostgreSQL&#8217;in <code class=\"language-\">datestyle<\/code> ayar\u0131na ba\u011fl\u0131d\u0131r.  Bu ayar\u0131 de\u011fi\u015ftirmek i\u00e7in <code class=\"language-\">SET datestyle = 'ISO, MDY'<\/code> gibi komutlar\u0131 kullanabilirsiniz.  Ancak, daha g\u00fcvenilir bir \u00e7\u00f6z\u00fcm, <code class=\"language-\">get_week_start_date()<\/code> fonksiyonunda oldu\u011fu gibi hafta ba\u015flang\u0131\u00e7 g\u00fcn\u00fcn\u00fc parametre olarak almak ve algoritmay\u0131 buna g\u00f6re ayarlamak olacakt\u0131r.<\/p>\n<p>2. <strong>Y\u0131l\u0131n 53. haftas\u0131 nas\u0131l i\u015flenir?<\/strong>  Bu durum, y\u0131l\u0131n son haftas\u0131n\u0131n k\u0131smen sonraki y\u0131la ait oldu\u011fu anlam\u0131na gelir.  <code class=\"language-\">get_week_start_date()<\/code> fonksiyonu gibi geli\u015fmi\u015f fonksiyonlar, bu durumu do\u011fru bir \u015fekilde ele almal\u0131d\u0131r.<\/p>\n<p>3. <strong>ISO 8601 standard\u0131 nas\u0131l kullan\u0131l\u0131r?<\/strong>  ISO 8601 standard\u0131, hafta numaralar\u0131n\u0131 ve tarih hesaplamalar\u0131n\u0131 standardize eder.  PostgreSQL&#8217;de ISO 8601 standard\u0131na uygun hafta numaras\u0131 hesaplamalar\u0131 i\u00e7in <code class=\"language-\">to_char(tarih, 'IW')<\/code> fonksiyonunu kullanabilirsiniz.<\/p>\n<p>4. <strong>Performans sorunlar\u0131 nas\u0131l giderilir?<\/strong>  <code class=\"language-\">EXPLAIN ANALYZE<\/code> komutu ile sorgular\u0131n\u0131z\u0131n y\u00fcr\u00fctme plan\u0131n\u0131 inceleyerek performans darbo\u011fazlar\u0131n\u0131 belirleyebilirsiniz.  \u0130ndeksler, materialized views ve sorgu optimizasyonu performans\u0131 art\u0131rmada yard\u0131mc\u0131 olur.<\/p>\n<p>5. <strong>Farkl\u0131 bir veritaban\u0131 sisteminde benzer bir i\u015flem nas\u0131l yap\u0131l\u0131r?<\/strong>  Di\u011fer veritaban\u0131 sistemlerinin de kendi tarih ve zaman fonksiyonlar\u0131 vard\u0131r.  Benzer bir i\u015flemi di\u011fer sistemlerde ger\u00e7ekle\u015ftirmek i\u00e7in, ilgili veritaban\u0131 sisteminin dok\u00fcmantasyonuna bakman\u0131z gerekir.<\/p>\n<p>Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"# PostgreSQL&#8217;de Hafta Numaras\u0131ndan Hafta Ba\u015flang\u0131\u00e7 Tarihini Bulma PostgreSQL veritaban\u0131n\u0131zda haftal\u0131k raporlama yap\u0131yorsunuz ve haftan\u0131n numaras\u0131ndan o haftan\u0131n&hellip;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[644],"tags":[],"class_list":{"0":"post-25604","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-postgresql","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL: Hafta Numaras\u0131ndan Hafta Ba\u015flang\u0131\u00e7 Tarihini Alma<\/title>\n<meta name=\"description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL: Hafta Numaras\u0131ndan Hafta Ba\u015flang\u0131\u00e7 Tarihini Alma\" \/>\n<meta property=\"og:description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-09T09:15:26+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PostgreSQL: Hafta Numaras\u0131ndan Hafta Ba\u015flang\u0131\u00e7 Tarihini Alma\",\"datePublished\":\"2025-07-09T09:15:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/\"},\"wordCount\":1123,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/\",\"name\":\"PostgreSQL: Hafta Numaras\u0131ndan Hafta Ba\u015flang\u0131\u00e7 Tarihini Alma\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-07-09T09:15:26+00:00\",\"description\":\"Hi\u00e7bir etiketi bulunamad\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: Hafta Numaras\u0131ndan Hafta Ba\u015flang\u0131\u00e7 Tarihini Alma\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL: Hafta Numaras\u0131ndan Hafta Ba\u015flang\u0131\u00e7 Tarihini Alma","description":"Hi\u00e7bir etiketi bulunamad\u0131.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/","og_locale":"tr_TR","og_type":"article","og_title":"PostgreSQL: Hafta Numaras\u0131ndan Hafta Ba\u015flang\u0131\u00e7 Tarihini Alma","og_description":"Hi\u00e7bir etiketi bulunamad\u0131.","og_url":"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-07-09T09:15:26+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"7 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PostgreSQL: Hafta Numaras\u0131ndan Hafta Ba\u015flang\u0131\u00e7 Tarihini Alma","datePublished":"2025-07-09T09:15:26+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/"},"wordCount":1123,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["PostgreSQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/","url":"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/","name":"PostgreSQL: Hafta Numaras\u0131ndan Hafta Ba\u015flang\u0131\u00e7 Tarihini Alma","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-07-09T09:15:26+00:00","description":"Hi\u00e7bir etiketi bulunamad\u0131.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-hafta-numarasindan-hafta-baslangic-tarihini-alma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: Hafta Numaras\u0131ndan Hafta Ba\u015flang\u0131\u00e7 Tarihini Alma"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/25604","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=25604"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/25604\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=25604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=25604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=25604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}