{"url":"https://iww.hateblo.jp/entry/20160524/date_sub","version":"1.0","width":"100%","author_name":"iww","description":"MySQL :: MySQL 5.6 \u30ea\u30d5\u30a1\u30ec\u30f3\u30b9\u30de\u30cb\u30e5\u30a2\u30eb :: 12.7 \u65e5\u4ed8\u304a\u3088\u3073\u6642\u9593\u95a2\u6570 SELECT DATE_SUB(NOW(), INTERVAL 7 DAY); -- 2016-05-17 21:11:47 SELECT SUBDATE(NOW(), 7); -- 2016-05-17 21:11:47 SELECT DATE_FORMAT(SUBDATE(NOW(), 7), \"%Y%m%d%H%i%s\"); -- 20160517211147","blog_url":"https://iww.hateblo.jp/","image_url":null,"provider_url":"https://hatena.blog","provider_name":"Hatena Blog","height":"190","blog_title":"\u63ee\u767a\u6027\u306e\u30e1\u30e2\uff12","published":"2016-05-24 00:00:00","author_url":"https://blog.hatena.ne.jp/iww/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fiww.hateblo.jp%2Fentry%2F20160524%2Fdate_sub\" title=\" \u5148\u9031\u306e\u65e5\u4ed8\u3092\u53d6\u5f97\u3059\u308b - \u63ee\u767a\u6027\u306e\u30e1\u30e2\uff12\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","categories":["MySQL"],"type":"rich","title":" \u5148\u9031\u306e\u65e5\u4ed8\u3092\u53d6\u5f97\u3059\u308b"}