{"blog_url":"https://hide-blo.hateblo.jp/","description":"Snowflake\u306b\u3066\u4ee5\u4e0b\u306eSQL\u3092\u5b9f\u884c\u3002 WITH target_date AS ( SELECT TO_DATE('20230128', 'YYYYMMDD') AS pnr_date ), date_ranges AS ( SELECT pnr_date, DATEADD('DAY', 1 - DAYOFWEEK(pnr_date), pnr_date) AS previous_saturday FROM target_date ), weeks AS ( SELECT previous_saturday, DATEADD('WEEK', SEQ4(), previous_saturda\u2026","blog_title":"Big Bro Hide\u2019s Blog","provider_url":"https://hatena.blog","width":"100%","title":"\u3010Snowflake\u30111\uff5e52\u9031\u307e\u3067\u306e\u7e70\u308a\u8fd4\u3057\u30ec\u30b3\u30fc\u30c9\u306e\u53d6\u5f97","url":"https://hide-blo.hateblo.jp/entry/2024/08/08/101751","type":"rich","provider_name":"Hatena Blog","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhide-blo.hateblo.jp%2Fentry%2F2024%2F08%2F08%2F101751\" title=\"\u3010Snowflake\u30111\uff5e52\u9031\u307e\u3067\u306e\u7e70\u308a\u8fd4\u3057\u30ec\u30b3\u30fc\u30c9\u306e\u53d6\u5f97 - Big Bro Hide\u2019s Blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_url":"https://blog.hatena.ne.jp/hideney/","version":"1.0","categories":["Snowflake"],"author_name":"hideney","published":"2024-08-08 10:17:51","height":"190"}