{"author_url":"https://blog.hatena.ne.jp/HTN20190109/","type":"rich","width":"100%","categories":["DB"],"blog_url":"https://htn20190109.hatenablog.com/","url":"https://htn20190109.hatenablog.com/entry/2023/04/19/223034","height":"190","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","title":"\u65e5\u6642\u6f14\u7b97","provider_name":"Hatena Blog","provider_url":"https://hatena.blog","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>","blog_title":"HTN20190109\u306e\u65e5\u8a18","published":"2023-04-19 22:30:34","version":"1.0","author_name":"HTN20190109","image_url":null}