{"id":538,"date":"2020-07-19T14:29:24","date_gmt":"2020-07-19T06:29:24","guid":{"rendered":"http:\/\/www.gbase8.cn\/?p=538"},"modified":"2020-09-17T05:28:43","modified_gmt":"2020-09-16T21:28:43","slug":"gbase-8a%e9%9b%86%e7%be%a4%e6%94%af%e6%8c%81%e6%af%ab%e7%a7%92%e7%9a%84%e5%ad%97%e6%ae%b5%e7%b1%bb%e5%9e%8b","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/538","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u96c6\u7fa4\u652f\u6301\u6beb\u79d2\u7684\u5b57\u6bb5\u7c7b\u578b"},"content":{"rendered":"<p>GBase 8a\u96c6\u7fa4\u652f\u6301\u6beb\u79d2\u7684\u5b57\u6bb5\u7c7b\u578b\u53ea\u6709datetime\u7c7b\u578b\u652f\u6301\u6beb\u79d2\uff0c6\u4f4d\u3002 \u5176\u5b83\u7684date,timestamp\u90fd\u4e0d\u652f\u6301<\/p>\n\n\n\n<p>\u5982\u4e0b\u662f\u6d4b\u8bd5\u7ed3\u679c<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">gbase&gt; create table t_ms(a date,b datetime,c timestamp);\nQuery OK, 0 rows affected (Elapsed: 00:00:00.46)\ngbase&gt; insert into t_ms values ('2020-03-08 12:13:14.123456','2020-03-08 12:13:14.234567','2020-03-08 12:13:14.345678');\nQuery OK, 1 row affected, 1 warning (Elapsed: 00:00:00.10)\ngbase&gt; show warnings;\n+-------+------+----------------------------------------+\n| Level | Code | Message |\n+-------+------+----------------------------------------+\n| Note | 1265 | Data truncated for column 'a' at row 1 |\n+-------+------+----------------------------------------+\n1 row in set (Elapsed: 00:00:00.00)\ngbase&gt; select * from t_ms;\n+------------+----------------------------+---------------------+\n| a | b | c |\n+------------+----------------------------+---------------------+\n| 2020-03-08 | 2020-03-08 12:13:14.234567 | 2020-03-08 12:13:14 |\n+------------+----------------------------+---------------------+\n1 row in set (Elapsed: 00:00:00.30)\ngbase&gt;<\/pre>","protected":false},"excerpt":{"rendered":"<p>\u5357\u5927\u901a\u7528GBase 8a\u96c6\u7fa4\u652f\u6301\u6beb\u79d2\u7684\u5b57\u6bb5\u7c7b\u578b\u53ea\u6709datetime\u7c7b\u578b\u652f\u6301\u6beb\u79d2\uff0c6\u4f4d\u3002 \u5176\u5b83\u7684date,timestamp\u90fd\u4e0d\u652f\u6301<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-538","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/538","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=538"}],"version-history":[{"count":2,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/538\/revisions"}],"predecessor-version":[{"id":1378,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/538\/revisions\/1378"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}