{"id":17,"date":"2011-05-30T16:10:06","date_gmt":"2011-05-30T07:10:06","guid":{"rendered":"http:\/\/www.whoocus.com\/blog\/wordpress\/?p=17"},"modified":"2011-05-30T16:10:06","modified_gmt":"2011-05-30T07:10:06","slug":"mysql-%e6%97%a5%e4%bb%98%e9%96%a2%e6%95%b0","status":"publish","type":"post","link":"https:\/\/www.blowfish.co.jp\/?p=17","title":{"rendered":"MySQL \u65e5\u4ed8\u95a2\u6570"},"content":{"rendered":"<p>\u25a0\u6708\u672b\u65e5\u3092\u6c42\u3081\u308b<br \/>\n\u203bMySQL4.0\u4ee5\u524d<br \/>\n[code]<br \/>\nSELECT DATE_SUB(CONCAT(PERIOD_ADD(DATE_FORMAT(&#8216;2006-12-15&#8217;, &#8216;%Y%m&#8217;), 1), &#8217;01&#8217;), INTERVAL &#8216;1&#8217; DAY) FROM dual;<br \/>\n[\/code]<\/p>\n<p>\u203bMySQL4.1.1\u4ee5\u964d<br \/>\n[code]<br \/>\nSELECT LAST_DAY(&#8216;2006-12-15&#8217;) FROM dual;<br \/>\n[\/code] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u25a0\u6708\u672b\u65e5\u3092\u6c42\u3081\u308b \u203bMySQL4.0\u4ee5\u524d [code] SELECT DATE_SUB(CONCAT(PERIOD_ADD(DATE_FORMAT(&#8216;2006-12-15&#8217;, &#8216;%Y% [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"saved_in_kubio":false,"footnotes":""},"categories":[11,4],"tags":[],"class_list":["post-17","post","type-post","status-publish","format-standard","hentry","category-mysql","category-tech"],"_links":{"self":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/17","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17"}],"version-history":[{"count":0,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/17\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}