{"author_name":"shinkufencer","blog_title":"\u30b3\u30fc\u30c9\u65e5\u9032\u6708\u6b69","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/s/shinkufencer/20180623/20180623013239.png","title":"BigQuery\u3067\u73fe\u5728\u304b\u3089\u898b\u305f\u5148\u6708\u6708\u521d\u65e5\u3001\u5148\u6708\u6708\u672b\u65e5\u3092\u6c42\u3081\u308b","version":"1.0","blog_url":"https://shinkufencer.hateblo.jp/","published":"2018-06-22 23:30:00","type":"rich","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fshinkufencer.hateblo.jp%2Fentry%2F2018%2F06%2F23%2F013400\" title=\"BigQuery\u3067\u73fe\u5728\u304b\u3089\u898b\u305f\u5148\u6708\u6708\u521d\u65e5\u3001\u5148\u6708\u6708\u672b\u65e5\u3092\u6c42\u3081\u308b - \u30b3\u30fc\u30c9\u65e5\u9032\u6708\u6b69\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","width":"100%","height":"190","url":"https://shinkufencer.hateblo.jp/entry/2018/06/23/013400","author_url":"https://blog.hatena.ne.jp/shinkufencer/","categories":["BigQuery","Tips"],"description":"\u975e\u30a8\u30f3\u30b8\u30cb\u30a2\u304b\u3089\u3082\u3089\u3063\u305f\u30af\u30a8\u30ea\u304c\u3059\u3054\u304b\u3063\u305f\u306e\u3067\u7d39\u4ecb \u524d\u63d0\u6761\u4ef6 STANDARD SQL\u3067\u3059 \u3084\u308a\u65b9 \u5148\u6708\u6708\u521d\u65e5 FORMAT_DATE(\"%Y%m%d\",DATE_TRUNC(DATE_SUB(CURRENT_DATE('Asia/Tokyo'), INTERVAL 1 MONTH), MONTH)) \u539f\u7406 # \u5f53\u65e5\u6771\u4eac\u6642\u9593 CURRENT_DATE('Asia/Tokyo') # \u5f53\u65e5\u6771\u4eac\u6642\u9593 \u304b\u3089 1\u30f6\u6708\u524d DATE_SUB(CURRENT_DATE('Asia/Tokyo'), INTERVAL 1 MONTH) # \u5f53\u65e5\u6771\u4eac\u6642\u9593 \u304b\u3089 1\u30f6\u6708\u524d \u3067 \u5e74\u6708\u60c5\u5831\u306e\u307f\u306b\u3059\u308b DATE_TRU\u2026"}