{"blog_url":"https://www.shigemk2.com/","width":"100%","provider_name":"Hatena Blog","published":"2018-10-11 20:07:01","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.shigemk2.com%2Fentry%2F2018%2F10%2F11%2F200701\" title=\"presto date_diff week month - by shigemk2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"presto date_diff week month","description":"date_diff\u3063\u3066week\u3068\u304bmonth\u5358\u4f4d\u3067\u3082\u3044\u3051\u3061\u3083\u3046\u3093\u3060\u306d\u3002 (EMR\u3067Presto 0.187\u3060\u3051\u3069) select date_diff('week', timestamp '2017-01-01 00:00:00', timestamp '2018-10-10 23:59:59') + 1; _col0 ------- 93 (1 row) select date_diff('month', timestamp '2017-01-01 00:00:00', timestamp '2018-10-10 23:59:59') + 1; _col0 ------- 22 (1 row)\u2026","blog_title":"by shigemk2","provider_url":"https://hatena.blog","height":"190","author_name":"shigemk2","type":"rich","image_url":null,"version":"1.0","categories":["Presto"],"author_url":"https://blog.hatena.ne.jp/shigemk2/","url":"https://www.shigemk2.com/entry/2018/10/11/200701"}