{"id":262,"date":"2024-05-13T16:12:33","date_gmt":"2024-05-13T07:12:33","guid":{"rendered":"https:\/\/ohyou.hopto.org\/?p=262"},"modified":"2025-04-06T13:22:57","modified_gmt":"2025-04-06T04:22:57","slug":"%e7%9b%b4%e5%89%8d%e3%81%ae%e6%8c%87%e5%ae%9a%e3%81%ae%e6%9b%9c%e6%97%a5-postgresql","status":"publish","type":"post","link":"https:\/\/ohyou.hopto.org\/?p=262","title":{"rendered":"\u76f4\u524d\u306e\u6307\u5b9a\u306e\u66dc\u65e5 (postgresql)"},"content":{"rendered":"\n<p class=\"has-extra-small-font-size\">\u30e1\u30e2\u3002<\/p>\n\n\n\n<p class=\"has-extra-small-font-size\">\u73fe\u5728\u65e5\u6642\u304b\u3089\u76f4\u524d\u306e\u65e5\u66dc\u65e5\u3092 Postgres \u3067\u51fa\u3059\u3002\u5168\u7136\u899a\u3048\u3089\u308c\u306a\u3044\u306e\u3067\u30e1\u30e2\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-extra-small-font-size\"><code>\u6b21\u306e\u65e5\u66dc\u65e5\nTO_DATE(CONCAT(EXTRACT(YEAR FROM CURRENT_TIMESTAMP), '_', EXTRACT(WEEK FROM CURRENT_TIMESTAMP), '_7'), 'IYYY_IW_ID')\n\n\u76f4\u524d\u306e\u65e5\u66dc\u65e5\nTO_DATE(CONCAT(EXTRACT(YEAR FROM CURRENT_TIMESTAMP + '-6 days'), '_', EXTRACT(WEEK FROM CURRENT_TIMESTAMP + '-6 days'), '_7'), 'IYYY_IW_ID')\n\n\uff12\u3064\u524d\u306e\u65e5\u66dc\u65e5\nTO_DATE(CONCAT(EXTRACT(YEAR FROM CURRENT_TIMESTAMP + '-13 days'), '_', EXTRACT(WEEK FROM CURRENT_TIMESTAMP + '-13 days'), '_7'), 'IYYY_IW_ID')<\/code><\/pre>\n\n\n\n<p class=\"has-extra-small-font-size\">TO_DATE(&#8216;\u897f\u66a6_\u9031\u756a\u53f7_\u66dc\u65e5\u756a\u53f7&#8217;, , &#8216;IYYY_IW_ID&#8217;))<br>\u66dc\u65e5\u756a\u53f7\u306f\u30011 \u304b\u3089 7 \u3067\u6708\u66dc\u304b\u3089\u65e5\u66dc\u3092\u6307\u5b9a\u3059\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-extra-small-font-size\"><code>\u4f8b\uff1a SELECT TO_DATE('2024-01-1', 'IYYY-IW-ID');\n\u7d50\u679c\uff1a2024-01-01<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code has-extra-small-font-size\"><code>\u4f8b\uff1a SELECT TO_DATE('2024-01-7', 'IYYY-IW-ID');\n\u7d50\u679c\uff1a2024-01-07<\/code><\/pre>\n\n\n\n<p class=\"has-extra-small-font-size\">0 \u3082\u6307\u5b9a\u3067\u304d\u308b\u304c\u3001\u6708\u66dc\u306e\u524d\u306e\u65e5\u66dc\u3092\u6307\u3059\u308f\u3051\u3067\u306f\u306a\u3044\u70b9\u306b\u6ce8\u610f\u3002\u7d1b\u3089\u308f\u3057\u3044\u306e\u3067 0 \u306f\u4f7f\u3044\u305f\u304f\u306a\u3044\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-extra-small-font-size\"><code>\u4f8b\uff1a SELECT TO_DATE('2024-01-0', 'IYYY-IW-ID');\n\u7d50\u679c\uff1a2024-01-07<\/code><\/pre>\n\n\n\n<p class=\"has-extra-small-font-size\">TO_DATE() \u306b\u3064\u3044\u3066\u3001\u8a73\u7d30\u306f\u3053\u3053<br><a href=\"https:\/\/www.postgresql.jp\/document\/9.2\/html\/functions-formatting.html\">https:\/\/www.postgresql.jp\/document\/9.2\/html\/functions-formatting.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30e1\u30e2\u3002 \u73fe\u5728\u65e5\u6642\u304b\u3089\u76f4\u524d\u306e\u65e5\u66dc\u65e5\u3092 Postgres \u3067\u51fa\u3059\u3002\u5168\u7136\u899a\u3048\u3089\u308c\u306a\u3044\u306e\u3067\u30e1\u30e2\u3002 TO_DATE(&#8216;\u897f\u66a6_\u9031\u756a\u53f7_\u66dc\u65e5\u756a\u53f7&#8217;, , &#8216;IYYY_IW_ID&#8217;))\u66dc\u65e5&hellip; <a class=\"more-link\" href=\"https:\/\/ohyou.hopto.org\/?p=262\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">\u76f4\u524d\u306e\u6307\u5b9a\u306e\u66dc\u65e5 (postgresql)<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[44,43],"class_list":["post-262","post","type-post","status-publish","format-standard","hentry","category-server","tag-postgresql","tag-sql","entry"],"_links":{"self":[{"href":"https:\/\/ohyou.hopto.org\/index.php?rest_route=\/wp\/v2\/posts\/262","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ohyou.hopto.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ohyou.hopto.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ohyou.hopto.org\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ohyou.hopto.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=262"}],"version-history":[{"count":7,"href":"https:\/\/ohyou.hopto.org\/index.php?rest_route=\/wp\/v2\/posts\/262\/revisions"}],"predecessor-version":[{"id":307,"href":"https:\/\/ohyou.hopto.org\/index.php?rest_route=\/wp\/v2\/posts\/262\/revisions\/307"}],"wp:attachment":[{"href":"https:\/\/ohyou.hopto.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ohyou.hopto.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ohyou.hopto.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}