{"author_name":"HTN20190109","published":"2023-04-19 22:30:34","provider_url":"https://hatena.blog","type":"rich","height":"190","version":"1.0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2023%2F04%2F19%2F223034\" title=\"\u65e5\u6642\u6f14\u7b97 - HTN20190109\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://htn20190109.hatenablog.com/entry/2023/04/19/223034","provider_name":"Hatena Blog","description":"MySQL (8.0.32)https://dev.mysql.com/doc/refman/8.0/ja/date-and-time-functions.html \u6587\u5b57\u5217\u2192\u65e5\u6642 SELECT STR_TO_DATE('2023-04-18 21:49:11','%Y-%m-%d %H:%i:%s'); \u65e5\u6642\u2192\u6587\u5b57\u5217 SELECT DATE_FORMAT( now(), '%Y-%m-%d %H:%i:%s'); \u5e74select extract(year from now() ); \u6708select extract(month from now() ); \u65e5select extract(day \u2026","blog_title":"HTN20190109\u306e\u65e5\u8a18","blog_url":"https://htn20190109.hatenablog.com/","image_url":null,"title":"\u65e5\u6642\u6f14\u7b97","author_url":"https://blog.hatena.ne.jp/HTN20190109/","categories":["DB"],"width":"100%"}