{"id":25432,"date":"2025-07-06T09:15:22","date_gmt":"2025-07-06T06:15:22","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/"},"modified":"2025-07-06T09:15:22","modified_gmt":"2025-07-06T06:15:22","slug":"postgresql-tarihten-hafta-numarasini-alma","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/","title":{"rendered":"PostgreSQL: Tarihten Hafta Numaras\u0131n\u0131 Alma"},"content":{"rendered":"<p># PostgreSQL&#8217;de Tarihten Hafta Numaras\u0131n\u0131 Alma<\/p>\n<p>PostgreSQL veritaban\u0131n\u0131zda tarih verileriniz var ve bu tarihlere ait hafta numaralar\u0131n\u0131 elde etmeniz gerekiyor mu?  \u00d6rne\u011fin, her haftan\u0131n sat\u0131\u015flar\u0131n\u0131 analiz etmek, haftal\u0131k raporlar olu\u015fturmak veya haftal\u0131k d\u00f6nemlere g\u00f6re veri filtreleme yapmak isteyebilirsiniz. Bu makalede, PostgreSQL&#8217;de tarih verisinden hafta numaras\u0131n\u0131 farkl\u0131 y\u00f6ntemlerle nas\u0131l elde edece\u011finizi, performans optimizasyonunu ve olas\u0131 sorunlar\u0131 ad\u0131m ad\u0131m \u00f6\u011freneceksiniz.  Veritaban\u0131n\u0131z\u0131n performans\u0131n\u0131 en \u00fcst d\u00fczeye \u00e7\u0131karmak i\u00e7in en uygun y\u00f6ntemi se\u00e7menizde size rehberlik edece\u011fiz.<\/p>\n<p><strong>PostgreSQL Tarih Fonksiyonlar\u0131na Giri\u015f: Hafta Numaras\u0131 Hesaplama<\/strong><\/p>\n<p>PostgreSQL&#8217;de tarih ve zaman i\u015flemleri i\u00e7in g\u00fc\u00e7l\u00fc fonksiyonlar mevcuttur.  Bunlardan biri de <code class=\"language-\">EXTRACT<\/code> fonksiyonudur.  Bu fonksiyon, bir tarih veya zaman de\u011ferinden belirli bir alan\u0131 (y\u0131l, ay, g\u00fcn, hafta vb.) ay\u0131klamay\u0131 sa\u011flar.  Ancak, hafta numaras\u0131n\u0131n hesaplanmas\u0131, y\u0131l\u0131n hangi g\u00fcn\u00fcnden haftan\u0131n ba\u015flang\u0131c\u0131n\u0131n say\u0131laca\u011f\u0131 gibi k\u00fclt\u00fcrel farkl\u0131l\u0131klara ba\u011fl\u0131 olarak de\u011fi\u015febilir.<\/p>\n<p><strong>Temel Kavramlar:<\/strong><\/p>\n<p>PostgreSQL&#8217;de hafta numaras\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131lan iki \u00f6nemli fakt\u00f6r vard\u0131r:<\/p>\n<p>* <strong>Hafta Ba\u015flang\u0131c\u0131:<\/strong> ISO 8601 standard\u0131na g\u00f6re haftan\u0131n ba\u015flang\u0131c\u0131 Pazartesi&#8217;dir.  Ancak, farkl\u0131 b\u00f6lgelerde veya uygulamalarda Pazar&#8217;\u0131 hafta ba\u015flang\u0131c\u0131 olarak kabul eden durumlar da olabilir.<br \/>\n* <strong>Y\u0131l\u0131n \u0130lk Haftas\u0131:<\/strong> Y\u0131l\u0131n ilk haftas\u0131n\u0131n nas\u0131l tan\u0131mland\u0131\u011f\u0131 da \u00f6nemlidir.  ISO 8601 standard\u0131na g\u00f6re, y\u0131l\u0131n ilk haftas\u0131 y\u0131l\u0131n ilk Per\u015fembe&#8217;sini i\u00e7eren haftad\u0131r.<\/p>\n<p>Bu farkl\u0131l\u0131klar, hafta numaras\u0131 hesaplamalar\u0131nda farkl\u0131 sonu\u00e7lara yol a\u00e7abilir.  Bu nedenle, hangi standard\u0131 kullanaca\u011f\u0131n\u0131z\u0131 belirlemek \u00f6nemlidir.<\/p>\n<p><strong>PostgreSQL&#8217;de Tarihten Hafta Numaras\u0131n\u0131 Alma: Ad\u0131m Ad\u0131m Uygulama<\/strong><\/p>\n<p><strong>\u00d6\u011frenme Yol Haritas\u0131:<\/strong><\/p>\n<p><strong>Yeni Ba\u015flayan:<\/strong><\/p>\n<p><strong>Ad\u0131m 1:<\/strong> <code class=\"language-\">EXTRACT<\/code> fonksiyonunu kullanarak hafta numaras\u0131n\u0131 almak:<\/p>\n<pre class=\"language-sql\"><code>SELECT EXTRACT(WEEK FROM tarih_sutunu) AS hafta_numarasi\nFROM tablo_adi;<\/code><\/pre>\n<p>Bu kod, <code class=\"language-\">tablo_adi<\/code> tablosundaki <code class=\"language-\">tarih_sutunu<\/code> s\u00fctunundaki her tarih i\u00e7in hafta numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.  <code class=\"language-\">EXTRACT(WEEK FROM ...)<\/code> fonksiyonu, PostgreSQL&#8217;in varsay\u0131lan hafta numaras\u0131 hesaplama y\u00f6ntemini kullan\u0131r. Bu y\u00f6ntem, genellikle ISO 8601 standard\u0131na uymaz ve Pazar&#8217;\u0131 hafta ba\u015flang\u0131c\u0131 olarak kabul eder.<\/p>\n<p><strong>Ad\u0131m 2:<\/strong>  <code class=\"language-\">EXTRACT<\/code> ile ISO 8601 standard\u0131na uygun hafta numaras\u0131 hesaplama:<\/p>\n<p>ISO 8601 standard\u0131na g\u00f6re hafta numaras\u0131 hesaplamak i\u00e7in daha karma\u015f\u0131k bir yakla\u015f\u0131m gereklidir. Bu, \u00f6zellikle y\u0131l\u0131n ba\u015flang\u0131c\u0131ndaki ve sonundaki haftalar\u0131n do\u011fru hesaplanmas\u0131 i\u00e7in \u00f6nemlidir.  Bu durum i\u00e7in <code class=\"language-\">to_char()<\/code> fonksiyonu kullan\u0131labilir.<\/p>\n<pre class=\"language-sql\"><code>SELECT to_char(tarih_sutunu, 'IW')::integer AS iso_hafta_numarasi\nFROM tablo_adi;<\/code><\/pre>\n<p><code class=\"language-\">to_char(tarih_sutunu, 'IW')<\/code> fonksiyonu ISO 8601 standard\u0131na g\u00f6re hafta numaras\u0131n\u0131 verir. <code class=\"language-\">::integer<\/code> k\u0131sm\u0131 ise sonucu tam say\u0131ya d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/p>\n<p><strong>Orta Seviye:<\/strong><\/p>\n<p><strong>Ger\u00e7ek Hayat \u00d6rne\u011fi:<\/strong><\/p>\n<p>Bir e-ticaret sitesinin g\u00fcnl\u00fck sat\u0131\u015f verilerini i\u00e7eren bir tablo oldu\u011funu d\u00fc\u015f\u00fcnelim.  Bu verileri haftal\u0131k olarak \u00f6zetlemek istiyoruz.<\/p>\n<pre class=\"language-sql\"><code>SELECT\n    EXTRACT(YEAR FROM siparis_tarihi) AS yil,\n    EXTRACT(WEEK FROM siparis_tarihi) AS hafta,\n    SUM(siparis_tutari) AS toplam_satis\nFROM\n    siparisler\nGROUP BY\n    yil, hafta\nORDER BY\n    yil, hafta;<\/code><\/pre>\n<p>Bu sorgu, her y\u0131l ve hafta i\u00e7in toplam sat\u0131\u015f miktar\u0131n\u0131 g\u00f6sterir.  Ancak, burada da varsay\u0131lan hafta numaras\u0131 hesab\u0131 kullan\u0131ld\u0131\u011f\u0131n\u0131 unutmay\u0131n.  ISO 8601 standard\u0131na uygun bir hesaplama i\u00e7in <code class=\"language-\">to_char()<\/code> fonksiyonunu kullanabilirsiniz.<\/p>\n<p><strong>Optimizasyon \u0130pu\u00e7lar\u0131:<\/strong><\/p>\n<p>* \u0130ndeksleme: <code class=\"language-\">tarih_sutunu<\/code> s\u00fctununa bir indeks eklemek sorgular\u0131n performans\u0131n\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131rabilir.<br \/>\n* Fonksiyonel \u0130ndeksler:  <code class=\"language-\">EXTRACT(WEEK FROM tarih_sutunu)<\/code> veya <code class=\"language-\">to_char(tarih_sutunu, 'IW')<\/code> fonksiyonlar\u0131n\u0131n sonu\u00e7lar\u0131na g\u00f6re bir fonksiyonel indeks olu\u015fturmak da performans\u0131 iyile\u015ftirebilir.<\/p>\n<p><strong>\u0130leri D\u00fczey:<\/strong><\/p>\n<p><strong>Performans Analizi:<\/strong><\/p>\n<p>Farkl\u0131 y\u00f6ntemlerin performans\u0131n\u0131 kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in <code class=\"language-\">EXPLAIN ANALYZE<\/code> komutunu kullanabilirsiniz.  \u00d6rne\u011fin:<\/p>\n<pre class=\"language-sql\"><code>EXPLAIN ANALYZE SELECT EXTRACT(WEEK FROM tarih_sutunu) FROM tablo_adi;\nEXPLAIN ANALYZE SELECT to_char(tarih_sutunu, 'IW')::integer FROM tablo_adi;<\/code><\/pre>\n<p>Bu komutlar, her sorgunun y\u00fcr\u00fct\u00fclme plan\u0131n\u0131 ve s\u00fcresini g\u00f6sterir.  B\u00f6ylece, hangi y\u00f6ntemin daha h\u0131zl\u0131 oldu\u011funu g\u00f6rebilirsiniz.<\/p>\n<p><strong>Edge Case&#8217;ler:<\/strong><\/p>\n<p>Y\u0131l\u0131n ba\u015flang\u0131c\u0131 ve sonundaki haftalar i\u00e7in do\u011fru hafta numaras\u0131 hesaplanmas\u0131 \u00f6nemlidir.  <code class=\"language-\">EXTRACT<\/code> ve <code class=\"language-\">to_char<\/code> fonksiyonlar\u0131n\u0131n bu durumlardaki davran\u0131\u015flar\u0131n\u0131 dikkatlice inceleyin ve gerekti\u011finde \u00f6zel durum y\u00f6netimi ekleyin.  \u00d6rne\u011fin, y\u0131l\u0131n ilk haftas\u0131n\u0131n hangi y\u0131la ait oldu\u011fu gibi durumlar\u0131 ele alman\u0131z gerekebilir.<\/p>\n<p><strong>PostgreSQL&#8217;de Hafta Numaras\u0131 Hesaplaman\u0131n Pratik Uygulamalar\u0131<\/strong><\/p>\n<p>PostgreSQL&#8217;de tarih verilerinden hafta numaras\u0131n\u0131 \u00e7\u0131karmak, \u00e7e\u015fitli ger\u00e7ek d\u00fcnya senaryolar\u0131nda olduk\u00e7a faydal\u0131d\u0131r. \u0130\u015fte birka\u00e7 \u00f6rnek:<\/p>\n<p>* <strong>Sat\u0131\u015f Analizi:<\/strong> Haftal\u0131k sat\u0131\u015f trendlerini analiz etmek ve performans\u0131 izlemek i\u00e7in kullan\u0131labilir.  [fatihsoysal.com](https:\/\/fatihsoysal.com) sitesindeki makalelerden birinde detayl\u0131 sat\u0131\u015f analizi \u00f6rnekleri bulabilirsiniz (burada varsay\u0131msal bir ba\u011flant\u0131d\u0131r, ger\u00e7ek bir ba\u011flant\u0131 eklenmelidir).<br \/>\n* <strong>\u00dcretim Takibi:<\/strong> \u00dcretim s\u00fcre\u00e7lerini haftal\u0131k olarak izlemek ve verimlili\u011fi art\u0131rmak i\u00e7in kullan\u0131labilir.<br \/>\n* <strong>Web Analiti\u011fi:<\/strong> Web sitesi trafi\u011fini haftal\u0131k olarak analiz etmek ve kullan\u0131c\u0131 davran\u0131\u015flar\u0131n\u0131 anlamak i\u00e7in kullan\u0131labilir.<br \/>\n* <strong>\u0130nsan Kaynaklar\u0131:<\/strong> \u00c7al\u0131\u015fanlar\u0131n performans\u0131n\u0131 haftal\u0131k olarak de\u011ferlendirmek ve iyile\u015ftirme alanlar\u0131n\u0131 belirlemek i\u00e7in kullan\u0131labilir.<br \/>\n* <strong>Finansal Raporlama:<\/strong> Haftal\u0131k finansal raporlar olu\u015fturmak ve mali durumu izlemek i\u00e7in kullan\u0131labilir.<\/p>\n<p><strong>Sonu\u00e7<\/strong><\/p>\n<p>PostgreSQL&#8217;de tarih verisinden hafta numaras\u0131n\u0131 almak i\u00e7in farkl\u0131 y\u00f6ntemler mevcuttur.  <code class=\"language-\">EXTRACT<\/code> ve <code class=\"language-\">to_char<\/code> fonksiyonlar\u0131, farkl\u0131 standartlara ve gereksinimlere g\u00f6re hafta numaras\u0131n\u0131 hesaplamay\u0131 sa\u011flar.  Performans optimizasyonu i\u00e7in indeksleme ve fonksiyonel indeksler kullan\u0131lmal\u0131d\u0131r.  Y\u0131l\u0131n ba\u015flang\u0131c\u0131 ve sonundaki haftalar gibi \u00f6zel durumlar dikkatlice ele al\u0131nmal\u0131d\u0131r. Do\u011fru y\u00f6ntemi se\u00e7mek, verilerinizin do\u011fru ve verimli bir \u015fekilde analiz edilmesini sa\u011flar.<\/p>\n<p><strong>S\u0131k\u00e7a Sorulan Sorular:<\/strong><\/p>\n<p>1. <strong>PostgreSQL&#8217;in varsay\u0131lan hafta numaras\u0131 hesaplama y\u00f6ntemi nedir?<\/strong>  Varsay\u0131lan y\u00f6ntem, genellikle Pazar&#8217;\u0131 hafta ba\u015flang\u0131c\u0131 olarak kabul eder ve ISO 8601 standard\u0131na uymaz.<br \/>\n2. <strong>ISO 8601 standard\u0131na uygun hafta numaras\u0131 nas\u0131l hesaplan\u0131r?<\/strong> <code class=\"language-\">to_char(tarih, 'IW')<\/code> fonksiyonu kullan\u0131labilir.<br \/>\n3. <strong>Hafta numaras\u0131 hesaplamalar\u0131nda performans\u0131 nas\u0131l art\u0131rabilirim?<\/strong> \u0130ndeksleme ve fonksiyonel indeksler kullanarak performans\u0131 art\u0131rabilirsiniz.<br \/>\n4. <strong>Y\u0131l\u0131n ilk haftas\u0131n\u0131n nas\u0131l tan\u0131mland\u0131\u011f\u0131 \u00f6nemli midir?<\/strong> Evet, y\u0131l\u0131n ilk haftas\u0131n\u0131n tan\u0131m\u0131, \u00f6zellikle y\u0131l\u0131n ba\u015flang\u0131c\u0131 ve sonundaki haftalar\u0131n numaraland\u0131r\u0131lmas\u0131nda \u00f6nemlidir.<br \/>\n5. <strong>Farkl\u0131 hafta ba\u015flang\u0131\u00e7 g\u00fcnleri i\u00e7in nas\u0131l bir yakla\u015f\u0131m izlenmelidir?<\/strong>  Bu durum i\u00e7in \u00f6zel SQL fonksiyonlar\u0131 yazabilir veya daha karma\u015f\u0131k sorgu yap\u0131lar\u0131n\u0131 kullanabilirsiniz.<\/p>\n<p>Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"# PostgreSQL&#8217;de Tarihten Hafta Numaras\u0131n\u0131 Alma PostgreSQL veritaban\u0131n\u0131zda tarih verileriniz var ve bu tarihlere ait hafta numaralar\u0131n\u0131 elde&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-25432","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: Tarihten Hafta Numaras\u0131n\u0131 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-tarihten-hafta-numarasini-alma\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL: Tarihten Hafta Numaras\u0131n\u0131 Alma\" \/>\n<meta property=\"og:description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-06T06:15:22+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=\"6 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PostgreSQL: Tarihten Hafta Numaras\u0131n\u0131 Alma\",\"datePublished\":\"2025-07-06T06:15:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/\"},\"wordCount\":1014,\"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-tarihten-hafta-numarasini-alma\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/\",\"name\":\"PostgreSQL: Tarihten Hafta Numaras\u0131n\u0131 Alma\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-07-06T06:15:22+00:00\",\"description\":\"Hi\u00e7bir etiketi bulunamad\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: Tarihten Hafta Numaras\u0131n\u0131 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: Tarihten Hafta Numaras\u0131n\u0131 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-tarihten-hafta-numarasini-alma\/","og_locale":"tr_TR","og_type":"article","og_title":"PostgreSQL: Tarihten Hafta Numaras\u0131n\u0131 Alma","og_description":"Hi\u00e7bir etiketi bulunamad\u0131.","og_url":"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-07-06T06:15:22+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"6 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PostgreSQL: Tarihten Hafta Numaras\u0131n\u0131 Alma","datePublished":"2025-07-06T06:15:22+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/"},"wordCount":1014,"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-tarihten-hafta-numarasini-alma\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/","url":"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/","name":"PostgreSQL: Tarihten Hafta Numaras\u0131n\u0131 Alma","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-07-06T06:15:22+00:00","description":"Hi\u00e7bir etiketi bulunamad\u0131.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-tarihten-hafta-numarasini-alma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: Tarihten Hafta Numaras\u0131n\u0131 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\/25432","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=25432"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/25432\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=25432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=25432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=25432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}