{"id":152,"date":"2018-09-19T18:28:45","date_gmt":"2018-09-19T10:28:45","guid":{"rendered":"https:\/\/wp.dj47.top\/?p=152"},"modified":"2021-10-20T16:19:03","modified_gmt":"2021-10-20T08:19:03","slug":"from_unixtime-%e6%a0%bc%e5%bc%8f%e5%8c%96mysql%e6%97%b6%e9%97%b4%e6%88%b3%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"https:\/\/www.djlog.cn\/?p=152","title":{"rendered":"FROM_UNIXTIME \u683c\u5f0f\u5316MYSQL\u65f6\u95f4\u6233\u51fd\u6570"},"content":{"rendered":"<p style=\"box-sizing: border-box; margin: 10px auto; padding: 0px; list-style-type: none; list-style-image: none; color: #444444; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 14px; background-color: #ffffff;\">\u51fd\u6570\uff1aFROM_UNIXTIME<br style=\"box-sizing: border-box;\" \/>\u4f5c\u7528\uff1a\u5c06MYSQL\u4e2d\u4ee5INT(11)\u5b58\u50a8\u7684\u65f6\u95f4\u4ee5&#8221;YYYY-MM-DD&#8221;\u683c\u5f0f\u6765\u663e\u793a\u3002<br style=\"box-sizing: border-box;\" \/>\u8bed\u6cd5\uff1a<span style=\"box-sizing: border-box; font-weight: bold;\">FROM_UNIXTIME(unix_timestamp,format)<\/span><\/p>\n<p style=\"box-sizing: border-box; margin: 10px auto; padding: 0px; list-style-type: none; list-style-image: none; color: #444444; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 14px; background-color: #ffffff;\">\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\u76ee\u540c\u6837\u7684\u4fee\u9970\u7b26\u3002<\/p>\n<p style=\"box-sizing: border-box; margin: 10px auto; padding: 0px; list-style-type: none; list-style-image: none; color: #444444; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 14px; background-color: #ffffff;\">\u6839\u636eformat\u5b57\u7b26\u4e32\u683c\u5f0f\u5316date\u503c\u3002<br style=\"box-sizing: border-box;\" \/>\u4e0b\u5217\u4fee\u9970\u7b26\u53ef\u4ee5\u88ab\u7528\u5728format\u5b57\u7b26\u4e32\u4e2d\uff1a<\/p>\n<p style=\"box-sizing: border-box; margin: 10px auto; padding: 0px; list-style-type: none; list-style-image: none; color: #444444; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 14px; background-color: #ffffff;\">%M \u6708\u540d\u5b57(January\u2026\u2026December)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%W \u661f\u671f\u540d\u5b57(Sunday\u2026\u2026Saturday)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%D \u6709\u82f1\u8bed\u524d\u7f00\u7684\u6708\u4efd\u7684\u65e5\u671f(1st, 2nd, 3rd, \u7b49\u7b49\u3002\uff09<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%Y \u5e74, \u6570\u5b57, 4 \u4f4d<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%y \u5e74, \u6570\u5b57, 2 \u4f4d<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%a \u7f29\u5199\u7684\u661f\u671f\u540d\u5b57(Sun\u2026\u2026Sat)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%d \u6708\u4efd\u4e2d\u7684\u5929\u6570, \u6570\u5b57(00\u2026\u202631)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%e \u6708\u4efd\u4e2d\u7684\u5929\u6570, \u6570\u5b57(0\u2026\u202631)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%m \u6708, \u6570\u5b57(01\u2026\u202612)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%c \u6708, \u6570\u5b57(1\u2026\u202612)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%b \u7f29\u5199\u7684\u6708\u4efd\u540d\u5b57(Jan\u2026\u2026Dec)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%j \u4e00\u5e74\u4e2d\u7684\u5929\u6570(001\u2026\u2026366)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%H \u5c0f\u65f6(00\u2026\u202623)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%k \u5c0f\u65f6(0\u2026\u202623)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%h \u5c0f\u65f6(01\u2026\u202612)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%I \u5c0f\u65f6(01\u2026\u202612)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%l \u5c0f\u65f6(1\u2026\u202612)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%i \u5206\u949f, \u6570\u5b57(00\u2026\u202659)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%r \u65f6\u95f4,12 \u5c0f\u65f6(hh:mm:ss [AP]M)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%T \u65f6\u95f4,24 \u5c0f\u65f6(hh:mm:ss)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%S \u79d2(00\u2026\u202659)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%s \u79d2(00\u2026\u202659)<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%p AM\u6216PM<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%w \u4e00\u4e2a\u661f\u671f\u4e2d\u7684\u5929\u6570(0=Sunday \u2026\u20266=Saturday \uff09<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%U \u661f\u671f(0\u2026\u202652), \u8fd9\u91cc\u661f\u671f\u5929\u662f\u661f\u671f\u7684\u7b2c\u4e00\u5929<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%u \u661f\u671f(0\u2026\u202652), \u8fd9\u91cc\u661f\u671f\u4e00\u662f\u661f\u671f\u7684\u7b2c\u4e00\u5929<br style=\"box-sizing: border-box;\" data-filtered=\"filtered\" \/>%% \u4e00\u4e2a\u6587\u5b57\u201c%\u201d\u3002<\/p>\n<p style=\"box-sizing: border-box; margin: 10px auto; padding: 0px; list-style-type: none; list-style-image: none; color: #444444; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 14px; background-color: #ffffff;\">\u4f8b\u5b50\uff1a<\/p>\n<p style=\"box-sizing: border-box; margin: 10px auto; padding: 0px; list-style-type: none; list-style-image: none; background-color: #ffffff;\"><span style=\"box-sizing: border-box;\"><span style=\"color: #444444; font-family: Tahoma, Arial, Helvetica, sans-serif;\"><span style=\"font-size: 14px;\"><strong>SELECT FROM_UNIXTIME(1234567890, &#8216;%Y-%m-%d %H:%i:%S&#8217;)<\/strong><\/span><\/span><\/span><\/p>\n<p style=\"box-sizing: border-box; margin: 10px auto; padding: 0px; list-style-type: none; list-style-image: none; color: #444444; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 14px; background-color: #ffffff;\"><span style=\"box-sizing: border-box; font-weight: bold;\">SELECT *,FROM_UNIXTIME(created, &#8216;%Y-%m-%d&#8217;) as riqi FROM `rc_ms_users`<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u51fd\u6570\uff1aFROM_UNIXTIME\u4f5c\u7528\uff1a\u5c06MYSQL\u4e2d\u4ee5INT(11)\u5b58\u50a8\u7684\u65f6\u95f4\u4ee5&#8221;YYYY-MM- [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[28],"class_list":["post-152","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/posts\/152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=152"}],"version-history":[{"count":0,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/posts\/152\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.djlog.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}