{"id":329,"date":"2011-07-03T03:42:41","date_gmt":"2011-07-03T03:42:41","guid":{"rendered":"http:\/\/hgtas.com\/?p=329"},"modified":"2011-07-03T03:58:34","modified_gmt":"2011-07-03T03:58:34","slug":"from_unixtimeunix_timestamp","status":"publish","type":"post","link":"https:\/\/508.me\/?p=329","title":{"rendered":"FROM_UNIXTIME(unix_timestamp)"},"content":{"rendered":"

FROM_UNIXTIME(unix_timestamp)
\n\u4ee5’YYYY-MM-DD HH:MM:SS’\u6216YYYYMMDDHHMMSS\u683c\u5f0f\u8fd4\u56deunix_timestamp\u53c2\u6570\u6240\u8868\u793a\u7684\u503c\uff0c\u53d6\u51b3\u4e8e\u51fd\u6570\u662f\u5728\u4e00\u4e2a\u5b57\u7b26\u4e32
\n\u8fd8\u662f\u6216\u6570\u5b57\u4e0a\u4e0b\u6587\u4e2d\u88ab\u4f7f\u7528\u3002
\nmysql> select FROM_UNIXTIME(875996580);
\n-> ‘1997-10-04 22:23:00’
\nmysql> select FROM_UNIXTIME(875996580) + 0;
\n-> 19971004222300<\/p>\n

FROM_UNIXTIME(unix_timestamp,format)
\n\u8fd4\u56de\u8868\u793a Unix \u65f6\u95f4\u6807\u8bb0\u7684\u4e00\u4e2a\u5b57\u7b26\u4e32\uff0c\u6839\u636eformat\u5b57\u7b26\u4e32\u683c\u5f0f\u5316\u3002format\u53ef\u4ee5\u5305\u542b\u4e0eDATE_FORMAT()\u51fd\u6570\u5217\u51fa\u7684\u6761
\n\u76ee\u540c\u6837\u7684\u4fee\u9970\u7b26\u3002
\nmysql> select FROM_UNIXTIME(UNIX_TIMESTAMP(),
\n‘%Y %D %M %h:%i:%s %x’);
\n-> ‘1997 23rd December 03:43:30 x’<\/p>\n

 <\/p>\n

http:\/\/seasun.iteye.com\/blog\/231921<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

FROM_UNIXTIME(unix_timestamp) \u4ee5’YYYY-MM-DD HH:MM: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17],"tags":[57,101],"_links":{"self":[{"href":"https:\/\/508.me\/index.php?rest_route=\/wp\/v2\/posts\/329"}],"collection":[{"href":"https:\/\/508.me\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/508.me\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/508.me\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/508.me\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=329"}],"version-history":[{"count":3,"href":"https:\/\/508.me\/index.php?rest_route=\/wp\/v2\/posts\/329\/revisions"}],"predecessor-version":[{"id":331,"href":"https:\/\/508.me\/index.php?rest_route=\/wp\/v2\/posts\/329\/revisions\/331"}],"wp:attachment":[{"href":"https:\/\/508.me\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/508.me\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/508.me\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}