<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<oembed>
  <author_name>shikaku</author_name>
  <author_url>https://blog.hatena.ne.jp/shikaku/</author_url>
  <blog_title>shikaku's blog</blog_title>
  <blog_url>https://blog.systemjp.net/</blog_url>
  <categories>
    <anon>SQL</anon>
  </categories>
  <description>翌月の月初日から 1 日引きます。 db=# SELECT DATE_TRUNC('month', now() + '1 months') + '-1 days'; ?column? ------------------------ 2010-02-28 00:00:00+09 (1 row)任意の日付指定で時間も23：59にしたいならこっち db=# SELECT DATE_TRUNC('month', date('2010-04-30')) + '1 months' + '-1 seconds'; ?column? ------------------------ 2010-04-30 2…</description>
  <height>190</height>
  <html>&lt;iframe src=&quot;https://hatenablog-parts.com/embed?url=https%3A%2F%2Fblog.systemjp.net%2Fentry%2F20110422%2Fp4&quot; title=&quot;PostgreSQL で月末日の取得 - shikaku&amp;#39;s blog&quot; class=&quot;embed-card embed-blogcard&quot; scrolling=&quot;no&quot; frameborder=&quot;0&quot; style=&quot;display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;&quot;&gt;&lt;/iframe&gt;</html>
  <image_url></image_url>
  <provider_name>Hatena Blog</provider_name>
  <provider_url>https://hatena.blog</provider_url>
  <published>2011-04-22 00:00:06</published>
  <title>PostgreSQL で月末日の取得</title>
  <type>rich</type>
  <url>https://blog.systemjp.net/entry/20110422/p4</url>
  <version>1.0</version>
  <width>100%</width>
</oembed>
