{"id":1116,"date":"2022-01-16T11:59:54","date_gmt":"2022-01-16T02:59:54","guid":{"rendered":"https:\/\/blog.wsd.sh\/?p=1116"},"modified":"2022-01-23T08:22:26","modified_gmt":"2022-01-22T23:22:26","slug":"golang-mariadb%e3%81%8b%e3%82%89%e5%8f%96%e5%be%97%e3%81%99%e3%82%8b%e6%97%a5%e4%bb%98%e3%81%8b%e3%82%890900%e3%82%92%e9%99%a4%e3%81%8f","status":"publish","type":"post","link":"https:\/\/blog.wsd.sh\/?p=1116","title":{"rendered":"<small>Golang mariaDB\u304b\u3089\u53d6\u5f97\u3059\u308b\u65e5\u4ed8\u304b\u3089+09:00\u3092\u9664\u304f<\/small>"},"content":{"rendered":"<p>\uff11\uff0emariaDB\u304b\u3089\u53d6\u5f97\u3059\u308b\u65e5\u4ed8\u304b\u3089+09:00\u3092\u9664\u304f<br \/>\n\u30fbSQL\u5074\u306eSELECT\u6587\u5185\u306e\u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u5909\u63db\u3067\u884c\u3046<\/p>\n<p>\uff12\uff0estep<br \/>\n(1) select\u6587\u306bDATE_FORMAT\u3092\u8ffd\u52a0\u3000<br \/>\n(2) format:\u2019%Y-%m-%d %H:%i:%s\u2019\u3067\u65e5\u4ed8\u304b\u3089+09:00\u3092\u9664\u304f<\/p>\n<p>\uff13\uff0ecode<br \/>\n(1) +09:00\u3092\u9664\u304f\u524d<\/p>\n<pre>\r\nSELECT \r\n\u3000 send_time\r\n\u30fb\u30fb\u30fb\r\n<\/pre>\n<p>(2) +09:00\u3092\u9664\u304f<\/p>\n<pre>\r\nSELECT\r\n   DATE_FORMAT(send_time ,\u2019%Y-%m-%d %H:%i:%s\u2019)\u3000AS send_time\r\n\u30fb\u30fb\u30fb\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uff11\uff0emariaDB\u304b\u3089\u53d6\u5f97\u3059\u308b\u65e5\u4ed8\u304b\u3089+09:00\u3092\u9664\u304f \u30fbSQL\u5074\u306eSELECT\u6587\u5185\u306e\u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u5909\u63db\u3067\u884c\u3046 \uff12\uff0estep (1) select\u6587\u306bDATE_FORMAT\u3092\u8ffd\u52a0\u3000 (2) format:\u2019%Y-%m&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1116"}],"collection":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1116"}],"version-history":[{"count":15,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1116\/revisions"}],"predecessor-version":[{"id":1214,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1116\/revisions\/1214"}],"wp:attachment":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}