{"author_name":"BG1","image_url":null,"url":"https://bg1.hatenablog.com/entry/2025/08/04/210000","published":"2025-08-04 21:00:00","author_url":"https://blog.hatena.ne.jp/BG1/","blog_url":"https://bg1.hatenablog.com/","blog_title":"\u8eca\u8f2a\u306ex\u767a\u660e ~B.G's Blog~","categories":["PostgreSQL"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fbg1.hatenablog.com%2Fentry%2F2025%2F08%2F04%2F210000\" title=\"DATE - \u8eca\u8f2a\u306ex\u767a\u660e ~B.G&#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>","description":"DATE\u306f\u3001\u5e74\u6708\u65e5\u307e\u3067\u306e\u65e5\u4ed8\u578b\u3002https://www.postgresql.jp/docs/9.4/datatype-datetime.html#DATATYPE-DATETIME-INPUT postgresdb1=# CREATE TABLE birth_date_list(id INT, name VARCHAR(50), birth_date DATE); CREATE TABLE postgresdb1=# INSERT INTO birth_date_list VALUES(1, 'Taro', '1990-3-25'); INSERT 0 1 postgresdb1=# INS\u2026","width":"100%","provider_name":"Hatena Blog","type":"rich","title":"DATE","height":"190","version":"1.0","provider_url":"https://hatena.blog"}