{"provider_name":"Hatena Blog","type":"rich","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fblog.systemjp.net%2Fentry%2F20110422%2Fp4\" title=\"PostgreSQL \u3067\u6708\u672b\u65e5\u306e\u53d6\u5f97 - shikaku&#39;s 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_name":"shikaku","provider_url":"https://hatena.blog","url":"https://blog.systemjp.net/entry/20110422/p4","title":"PostgreSQL \u3067\u6708\u672b\u65e5\u306e\u53d6\u5f97","width":"100%","description":"\u7fcc\u6708\u306e\u6708\u521d\u65e5\u304b\u3089 1 \u65e5\u5f15\u304d\u307e\u3059\u3002 db=# SELECT DATE_TRUNC('month', now() + '1 months') + '-1 days'; ?column? ------------------------ 2010-02-28 00:00:00+09 (1 row)\u4efb\u610f\u306e\u65e5\u4ed8\u6307\u5b9a\u3067\u6642\u9593\u308223\uff1a59\u306b\u3057\u305f\u3044\u306a\u3089\u3053\u3063\u3061 db=# SELECT DATE_TRUNC('month', date('2010-04-30')) + '1 months' + '-1 seconds'; ?column? ------------------------ 2010-04-30 2\u2026","published":"2011-04-22 00:00:06","version":"1.0","categories":["SQL"],"blog_title":"shikaku's blog","blog_url":"https://blog.systemjp.net/","author_url":"https://blog.hatena.ne.jp/shikaku/","height":"190","image_url":null}