{"id":70,"date":"2014-08-24T01:19:21","date_gmt":"2014-08-23T17:19:21","guid":{"rendered":"http:\/\/blog.qdac.cc\/?p=70"},"modified":"2014-08-24T01:19:21","modified_gmt":"2014-08-23T17:19:21","slug":"postgresql%e7%9a%84date_partextract%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"https:\/\/blog.qdac.cc\/?p=70","title":{"rendered":"PostgreSQL\u7684date_part\/extract\u51fd\u6570"},"content":{"rendered":"<p style=\"color: #454545;\">PostgreSQL\u53ef\u4ee5\u4f7f\u7528datepart\/Extract\u4ece\u65e5\u671f\u65f6\u95f4\u7c7b\u578b\u4e2d\u62bd\u53d6\u90e8\u5206\u5185\u5bb9\uff0c\u5e2e\u52a9\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n<p style=\"color: #454545;\">\n<p style=\"color: #454545;\">EXTRACT(fieldFROMsource)<\/p>\n<p style=\"color: #454545;\">extract\u51fd\u6570\u4ece\u65e5\u671f\/\u65f6\u95f4\u6570\u503c\u91cc\u62bd\u53d6\u5b50\u57df\uff0c\u6bd4\u5982\u5e74\u3001\u5c0f\u65f6\u7b49\u3002\u00a0source\u5fc5\u987b\u662f\u4e00\u4e2a typetimestamp\uff0ctime\uff0cinterval\u7c7b\u578b\u7684\u503c \u8868\u8fbe\u5f0f(\u7c7b\u578b\u4e3adate\u7684\u8868\u8fbe\u5f0f\u5c06\u8f6c\u6362\u4e3atimestamp\uff0c\u56e0\u6b64\u4e5f\u53ef\u4ee5\u7528)\u3002field\u662f\u4e00\u4e2a\u6807\u8bc6\u7b26\u6216\u8005\u5b57\u7b26\u4e32\uff0c\u5b83\u6307\u5b9a\u4ece\u6e90\u6570\u636e\u4e2d\u62bd\u53d6\u7684\u57df\u3002\u00a0extract\u51fd\u6570\u8fd4\u56de\u7c7b\u578b\u4e3a double precision \u7684\u6570\u503c\u3002\u4e0b\u5217\u6570\u503c\u662f\u6709\u6548\u6570\u636e\u57df\u7684\u540d\u5b57\uff1a<\/p>\n<p style=\"color: #454545;\">\n<p style=\"color: #454545;\">\n<p style=\"color: #454545;\">century<\/p>\n<p style=\"color: #454545;\">\u4e16\u7eaa<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(CENTURY FROM TIMESTAMP '2000-12-16 12:21:13');\r\nResult:20\r\nSELECT EXTRACT(CENTURY FROM TIMESTAMP '2001-02-16 20:38:40');\r\nResult:21<\/pre>\n<p style=\"color: #454545;\">\u7b2c\u4e00\u4e2a\u4e16\u7eaa\u4ece 0001-01-01 00:00:00 AD \u5f00\u59cb\uff0c\u5c3d\u7ba1\u90a3\u65f6\u5019\u4eba\u4eec\u8fd8\u4e0d\u77e5\u9053 \u8fd9\u662f\u7b2c\u4e00\u4e2a\u4e16\u7eaa\u3002\u8fd9\u4e2a\u5b9a\u4e49\u9002\u7528\u4e8e\u6240\u6709\u4f7f\u7528\u9633\u5386\u7684\u56fd\u5bb6\u3002\u6ca1\u6709 0 \u4e16\u7eaa\uff0c \u6211\u4eec\u76f4\u63a5\u4ece\u516c\u5143\u524d 1 \u4e16\u7eaa\u5230\u516c\u5143 1 \u4e16\u7eaa\u3002 \u5982\u679c\u4f60\u8ba4\u4e3a\u8fd9\u4e2a\u4e0d\u5408\u7406\uff0c\u90a3\u4e48\u8bf7\u628a\u62b1\u6028\u53d1\u7ed9\uff1a\u68b5\u8482\u5188\uff0c\u7f57\u9a6c\u5723\u5f7c\u5f97\u6559\u5802\uff0c\u6559\u7687\u6536<\/p>\n<p style=\"color: #454545;\">PostgreSQL8.0 \u4ee5\u524d\u7248\u672c\u91cc\u5e76\u4e0d\u9075\u5faa\u4e16\u7eaa\u7684\u4e60\u60ef\u7f16\u53f7\uff0c\u53ea\u662f\u628a\u5e74\u4efd\u9664\u4ee5 100 \u3002<\/p>\n<p style=\"color: #454545;\">day<\/p>\n<p style=\"color: #454545;\">(\u6708\u4efd)\u91cc\u7684\u5929(1-31)<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(DAY FROM TIMESTAMP '2001-02-16 20:38:40');\r\nResult:16<\/pre>\n<p style=\"color: #454545;\">decade<\/p>\n<p style=\"color: #454545;\">\u5e74\u4efd\u9664\u4ee5 10<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(DECADE FROM TIMESTAMP '2001-02-16 20:38:40');\r\nResult:200<\/pre>\n<p style=\"color: #454545;\">dow<\/p>\n<p style=\"color: #454545;\">\u5468\u4e2d\u5929\u7684\u7d22\u5f15(0-6 \uff1b\u661f\u671f\u5929\u662f 0)<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(DOW FROM TIMESTAMP '2001-02-16 20:38:40');\r\nResult:5<\/pre>\n<p style=\"color: #454545;\">\u8bf7\u6ce8\u610f\uff0cextract\u7684\u5468\u4e2d\u5929\u7f16\u53f7\u548cto_char(&#8230;\uff0c &#8216;D&#8217;)\u51fd\u6570\u4e0d\u540c\u3002<\/p>\n<p style=\"color: #454545;\">doy<\/p>\n<p style=\"color: #454545;\">\u4e00\u5e74\u7684\u7b2c\u51e0\u5929(1-365\/366)<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(DOY FROM TIMESTAMP '2001-02-16 20:38:40');\r\nResult:47<\/pre>\n<p style=\"color: #454545;\">epoch<\/p>\n<p style=\"color: #454545;\">\u5bf9\u4e8edate\u548ctimestamp\u503c\u800c\u8a00\uff0c\u662f\u81ea 1970-01-01 00:00:00-00 \u4ee5\u6765\u7684\u79d2\u6570 (\u7ed3\u679c\u53ef\u80fd\u662f\u8d1f\u6570)\uff1b\u5bf9\u4e8einterval\u503c\u800c\u8a00\uff0c\u5b83\u662f\u65f6\u95f4\u95f4\u9694\u7684\u603b\u79d2\u6570\u3002<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40.12-08');\r\n\u7ed3\u679c:982384720.12\r\n\r\nSELECT EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours');\r\n\u7ed3\u679c:442800<\/pre>\n<p style=\"color: #454545;\">\u4e0b\u9762\u662f\u628a epoch \u503c\u8f6c\u6362\u56de\u65f6\u95f4\u6233\u7684\u65b9\u6cd5\uff1a<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720.12 * INTERVAL '1 second';<\/pre>\n<p style=\"color: #454545;\">(Theto_timestampfunction encapsulates the above conversion.)<\/p>\n<p style=\"color: #454545;\">hour<\/p>\n<p style=\"color: #454545;\">The hour field (0 &#8211; 23)\u5c0f\u65f6\u57df(0-23)<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(HOUR FROM TIMESTAMP '2001-02-16 20:38:40');\r\n\u7ed3\u679c:20<\/pre>\n<p style=\"color: #454545;\">isodow<\/p>\n<p style=\"color: #454545;\">\u5468\u4e2d\u7684\u7b2c\u51e0\u5929 [1-7] \u661f\u671f\u4e00\uff1a1) \u661f\u671f\u5929\uff1a(7)\u3002<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(ISODOW FROM TIMESTAMP '2001-02-18 20:38:40');\r\n\u7ed3\u679c:7<\/pre>\n<p style=\"color: #454545;\">dow\u9664\u4e86\u661f\u671f\u5929\u5916\uff0c\u90fd\u76f8\u540c\u3002\u8fd9\u4e0eISO8601\u6807\u51c6\u5468\u4e2d\u7684\u7b2c\u51e0\u5929\u7f16\u7801\u76f8\u5339\u914d\u3002 matches theISO8601 day of the week numbering.<\/p>\n<p style=\"color: #454545;\">isoyear<\/p>\n<p style=\"color: #454545;\">\u65e5\u671f\u4e2d\u7684ISO8601\u6807\u51c6\u5e74\uff08\u4e0d\u9002\u7528\u4e8e\u95f4\u9694\uff09\u3002<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(ISOYEAR FROM DATE '2006-01-01');\r\n\u7ed3\u679c:2005\r\nSELECT EXTRACT(ISOYEAR FROM DATE '2006-01-02');\r\n\u7ed3\u679c:2006<\/pre>\n<p style=\"color: #454545;\">\u6bcf\u4e2a\u5e26\u6709\u661f\u671f\u4e00\u5f00\u59cb\u7684\u5468\u4e2d\u5305\u542b1\u67084\u65e5\u7684ISO\u5e74\uff0c \u6240\u4ee5\u5728\u5e74\u521d\u76841\u6708\u621612\u6708\u4e0b\u65ec\u7684ISO\u5e74\u53ef\u80fd\u4f1a\u4e0d\u540c\u4e0e\u9633\u5386\u7684\u5e74\u3002 \u89c1week\u83b7\u53d6\u66f4\u591a\u4fe1\u606f\u3002<\/p>\n<p style=\"color: #454545;\">\u8fd9\u4e2a\u57df\u4e0d\u80fd\u7528\u4e8e PostgreSQL 8.3\u4e4b\u524d\u7684\u7248\u672c\u3002<\/p>\n<p style=\"color: #454545;\">microseconds<\/p>\n<p style=\"color: #454545;\">\u79d2\u57df(\u5305\u62ec\u5c0f\u6570\u90e8\u5206)\u4e58\u4ee5 1\uff0c000\uff0c000 \u3002\u8bf7\u6ce8\u610f\u5b83\u5305\u62ec\u5168\u90e8\u7684\u79d2\u3002<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(MICROSECONDS FROM TIME '17:12:28.5');\r\n\u7ed3\u679c:28500000<\/pre>\n<p style=\"color: #454545;\">millennium<\/p>\n<p style=\"color: #454545;\">\u5343\u5e74<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(MILLENNIUM FROM TIMESTAMP '2001-02-16 20:38:40');\r\n\u7ed3\u679c:3<\/pre>\n<p style=\"color: #454545;\">20 \u4e16\u7eaa(19xx \u5e74)\u91cc\u9762\u7684\u5e74\u4efd\u5728\u7b2c\u4e8c\u4e2a\u5343\u5e74\u91cc\u3002\u7b2c\u4e09\u4e2a\u5343\u5e74\u4ece 2001 \u5e74 1 \u6708 1 \u65e5\u96f6\u65f6\u5f00\u59cb\u3002<\/p>\n<p style=\"color: #454545;\">PostgreSQL8.0 \u4e4b\u524d\u7684\u7248\u672c\u5e76\u4e0d\u9075\u5faa\u5343\u5e74\u7f16\u53f7\u7684\u4e60\u60ef\uff0c\u53ea\u662f\u8fd4\u56de\u5e74\u4efd\u9664\u4ee5 1000 \u3002<\/p>\n<p style=\"color: #454545;\">milliseconds<\/p>\n<p style=\"color: #454545;\">\u79d2\u57df(\u5305\u62ec\u5c0f\u6570\u90e8\u5206)\u4e58\u4ee5 1000 \u3002\u8bf7\u6ce8\u610f\u5b83\u5305\u62ec\u5b8c\u6574\u7684\u79d2\u3002<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(MILLISECONDS FROM TIME '17:12:28.5');\r\nResult:28500<\/pre>\n<p style=\"color: #454545;\">minute<\/p>\n<p style=\"color: #454545;\">\u5206\u949f\u57df(0-59)<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(MINUTE FROM TIMESTAMP '2001-02-16 20:38:40');\r\nResult:38<\/pre>\n<p style=\"color: #454545;\">month<\/p>\n<p style=\"color: #454545;\">Fortimestampvalues\uff0c the number of the month within the year (1 &#8211; 12) ; forintervalvalues the number of months\uff0c modulo 12 (0 &#8211; 11) \u5bf9\u4e8etimestamp\u503c\uff0c\u5b83\u662f\u4e00\u5e74\u91cc\u7684\u6708\u4efd\u6570(1-12)\uff1b \u5bf9\u4e8einterval\u503c\uff0c\u5b83\u662f\u6708\u7684\u7f16\u53f7\uff0c\u7136\u540e\u5bf9 12 \u53d6\u6a21(0-11)<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(MONTH FROM TIMESTAMP '2001-02-16 20:38:40');\r\nResult:2\r\n\r\nSELECT EXTRACT(MONTH FROM INTERVAL '2 years 3 months');\r\nResult:3\r\n\r\nSELECT EXTRACT(MONTH FROM INTERVAL '2 years 13 months');\r\nResult:1<\/pre>\n<p style=\"color: #454545;\">quarter<\/p>\n<p style=\"color: #454545;\">\u65e5\u671f\u4e2d\u5e74\u6240\u5728\u5b63\u5ea6(1-4)(\u4ec5\u7528\u4e8e timestamp \u503c)<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(QUARTER FROM TIMESTAMP '2001-02-16 20:38:40');\r\nResult:1<\/pre>\n<p style=\"color: #454545;\">second<\/p>\n<p style=\"color: #454545;\">\u79d2\u57df\uff0c\u5305\u62ec\u5c0f\u6570\u90e8\u5206(0-59)<a style=\"color: #9f9f9f;\" href=\"http:\/\/www.highgo.com.cn\/docs\/docs90cn\/functions-datetime.html#FTN.AEN13187\" target=\"_blank\">[1]<\/a><\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(SECOND FROM TIMESTAMP '2001-02-16 20:38:40');\r\nResult:40\r\n\r\nSELECT EXTRACT(SECOND FROM TIME '17:12:28.5');\r\nResult:28.5<\/pre>\n<p style=\"color: #454545;\">timezone<\/p>\n<p style=\"color: #454545;\">\u4e0eUTC\u7684\u65f6\u533a\u504f\u79fb\u91cf\uff0c\u4ee5\u79d2\u8bb0\u3002\u6b63\u6570\u5bf9\u5e94 UTC \u4e1c\u8fb9\u7684\u65f6\u533a\uff0c\u8d1f\u6570\u5bf9\u5e94 UTC \u897f\u8fb9\u7684\u65f6\u533a<\/p>\n<p style=\"color: #454545;\">timezone_hour<\/p>\n<p style=\"color: #454545;\">\u65f6\u533a\u504f\u79fb\u91cf\u7684\u5c0f\u65f6\u90e8\u5206\u3002<\/p>\n<p style=\"color: #454545;\">timezone_minute<\/p>\n<p style=\"color: #454545;\">\u65f6\u533a\u504f\u79fb\u91cf\u7684\u5206\u949f\u90e8\u5206\u3002<\/p>\n<p style=\"color: #454545;\">week<\/p>\n<p style=\"color: #454545;\">\u8be5\u5929\u5728\u6240\u5728\u7684\u5e74\u4efd\u91cc\u662f\u7b2c\u51e0\u5468\u3002 (ISO8601)\u5b9a\u4e49\u4e00\u5e74\u7684\u7b2c\u4e00\u5468\u5305\u542b\u8be5\u5e74\u7684\u4e00\u6708\u56db\u65e5(ISO-8601 \u7684\u5468\u4ece\u661f\u671f\u4e00\u5f00\u59cb)\u3002 \u6362\u53e5\u8bdd\u8bf4\uff0c\u4e00\u5e74\u7684\u7b2c\u4e00\u4e2a\u661f\u671f\u56db\u5728\u7b2c\u4e00\u5468\u3002(\u53ea\u7528\u4e8e timestamp \u503c)<\/p>\n<p style=\"color: #454545;\">\u56e0\u6b64\uff0c\u4e00\u6708\u7684\u5934\u51e0\u5929\u53ef\u80fd\u662f\u524d\u4e00\u5e74\u7684\u7b2c 52 \u6216\u8005\u7b2c 53 \u5468\u3002 \u6bd4\u5982\uff0c2005-01-01\u662f 2004 \u5e74\u7684\u7b2c 53 \u5468\uff0c\u800c2006-01-01\u662f 2005 \u5e74\u7684\u7b2c 52 \u5468<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(WEEK FROM TIMESTAMP '2001-02-16 20:38:40');\r\nResult:7<\/pre>\n<p style=\"color: #454545;\">year<\/p>\n<p style=\"color: #454545;\">\u5e74\u4efd\u57df\u3002\u8981\u8bb0\u4f4f\u8fd9\u91cc\u6ca1\u67090 AD\uff0c\u6240\u4ee5\u4eceAD\u5e74\u91cc\u62bd\u53d6BC\u5e74\u5e94\u8be5\u5c0f\u5fc3\u4e9b<\/p>\n<pre class=\"SCREEN\" style=\"color: #454545;\">SELECT EXTRACT(YEAR FROM TIMESTAMP '2001-02-16 20:38:40');\r\nResult:2001<\/pre>\n<p style=\"color: #454545;\">\n<p style=\"color: #454545;\">extract\u51fd\u6570\u4e3b\u8981\u7684\u7528\u9014\u662f\u8fd0\u7b97\u3002\u5bf9\u4e8e\u7528\u4e8e\u663e\u793a\u7684\u65e5\u671f\/\u65f6\u95f4\u6570\u503c\u683c\u5f0f\u5316\uff0c\u89c1<a style=\"color: #9f9f9f;\" href=\"http:\/\/www.highgo.com.cn\/docs\/docs90cn\/functions-formatting.html\" target=\"_blank\">Section 9.8<\/a>\u3002<\/p>\n<p style=\"color: #454545;\">date_part\u51fd\u6570\u662f\u4eff\u7167\u5728\u4f20\u7edf\u7684Ingres\u51fd\u6570\u3002\u7b49\u6548\u4e8e SQL \u6807\u51c6\u51fd\u6570extract\uff1a<\/p>\n<pre class=\"SYNOPSIS\" style=\"color: #454545;\">date_part('field'\uff0csource)<\/pre>\n<p style=\"color: #454545;\">Note that here thefieldparameter needs to be a string value\uff0c not a name. The valid field names for\u00a0date_partare the same as for\u00a0extract. \u8bf7\u6ce8\u610f\u8fd9\u91cc\u7684field\u53c2\u6570\u5fc5\u987b\u662f\u4e00\u4e2a\u5b57\u7b26\u4e32\u503c\uff0c\u800c\u4e0d\u662f\u4e00\u4e2a\u540d\u5b57\u3002\u00a0date_part\u7684\u6709\u6548\u57df\u540d\u53c2\u6570\u548cextract\u7684\u4e00\u6837\u3002<\/p>\n<pre class=\"SCREEN \" style=\"color: #454545;\">SELECT date_part('day'\uff0c TIMESTAMP '2001-02-16 20:38:40');\r\nResult:16\r\n\r\nSELECT date_part('hour'\uff0c INTERVAL '4 hours 3 minutes');\r\nResult:4<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL\u53ef\u4ee5\u4f7f\u7528datepa [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[4],"tags":[],"class_list":["post-70","post","type-post","status-publish","format-standard","hentry","category-pgsql"],"views":40947,"_links":{"self":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/70","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=70"}],"version-history":[{"count":1,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/70\/revisions"}],"predecessor-version":[{"id":71,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/70\/revisions\/71"}],"wp:attachment":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=70"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=70"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=70"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}