{"id":2756,"date":"2021-01-04T17:41:33","date_gmt":"2021-01-04T09:41:33","guid":{"rendered":"https:\/\/www.gbase8.cn\/?p=2756"},"modified":"2021-01-04T18:09:39","modified_gmt":"2021-01-04T10:09:39","slug":"gbase-8a%e5%b0%86%e6%97%a5%e6%9c%9f%e8%bd%ac%e5%ad%97%e7%ac%a6%e4%b8%b2to_char%e5%87%bd%e6%95%b0%e5%8a%9f%e8%83%bd%e4%bb%8b%e7%bb%8d%e5%92%8c%e6%a0%b7%e4%be%8b","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/2756","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u5c06\u65e5\u671f\u8f6c\u5b57\u7b26\u4e32to_char\u51fd\u6570\u529f\u80fd\u4ecb\u7ecd\u548c\u6837\u4f8b"},"content":{"rendered":"\n<p>GBase 8a\u63d0\u4f9b\u4e86to_char\u51fd\u6570\uff0c\u6309\u7167\u6307\u5b9a\u683c\u5f0f\uff0c\u5c06\u65e5\u671f\u65f6\u95f4\u8f6c\u5316\u4e3a\u5b57\u7b26\u4e32\u3002\u672c\u6587\u4ecb\u7ecd\u8be5\u51fd\u6570\u7684\u8bed\u6cd5\u548c\u4f7f\u7528\u6837\u4f8b\u3002<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u76ee\u5f55\u5bfc\u822a<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2d5086e53ae\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2d5086e53ae\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E8%AF%AD%E6%B3%95\" >\u8bed\u6cd5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E8%AF%B4%E6%98%8E\" >\u8bf4\u660e<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E5%8F%82%E6%95%B0\" >\u53c2\u6570<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E7%94%A8%E4%BE%8B\" >\u7528\u4f8b<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E5%B9%B4%EF%BC%9AY%E3%80%81YY%EF%BC%88RR%E3%80%81YYY%E3%80%81YYYYRRRR\" >\u5e74\uff1aY\u3001YY\uff08RR)\u3001YYY\u3001YYYY(RRRR)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E5%B8%A6%E9%80%97%E5%8F%B7%E7%9A%84%E5%B9%B4_YYYY\" >\u5e26\u9017\u53f7\u7684\u5e74:Y,YYY<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E5%B9%B4%E5%BA%A6%E6%A0%87%E8%AF%86_AD%E3%80%81BC\" >\u5e74\u5ea6\u6807\u8bc6:AD\u3001BC<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E6%9C%88%E4%BB%BD\" >\u6708\u4efd<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E6%95%B0%E5%AD%97%E6%9C%88%E4%BB%BD01-12_MM\" >\u6570\u5b57\u6708\u4efd(01-12):MM<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E5%85%A8%E9%95%BF%E9%A6%96%E5%AD%97%E6%AF%8D%E5%A4%A7%E5%86%99%E6%9C%88%E4%BB%BD_MONTH%E3%80%81Month%E3%80%81month\" >\u5168\u957f\u9996\u5b57\u6bcd\u5927\u5199\u6708\u4efd:MONTH\u3001Month\u3001month<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E7%BC%A9%E5%86%99%E9%A6%96%E5%AD%97%E6%AF%8D%E5%A4%A7%E5%86%99%E6%9C%88%E4%BB%BD%EF%BC%9AMON%E3%80%81Mon%E3%80%81mon\" >\u7f29\u5199\u9996\u5b57\u6bcd\u5927\u5199\u6708\u4efd\uff1aMON\u3001Mon\u3001mon<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E7%BD%97%E9%A9%AC%E6%95%B0%E5%AD%97%E7%9A%84%E6%9C%88%E4%BB%BD_RM%E3%80%81rm\" >\u7f57\u9a6c\u6570\u5b57\u7684\u6708\u4efd:RM\u3001rm<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E6%97%A5%E6%9C%9F\" >\u65e5\u671f<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E4%B8%80%E5%B9%B4%E4%B8%AD%E7%9A%84%E7%AC%AC%E5%87%A0%E5%A4%A9_DDD\" >\u4e00\u5e74\u4e2d\u7684\u7b2c\u51e0\u5929:DDD<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E4%B8%80%E4%B8%AA%E6%9C%88%E4%B8%AD%E7%9A%84%E7%AC%AC%E5%87%A0%E5%A4%A9_DD_01-31\" >\u4e00\u4e2a\u6708\u4e2d\u7684\u7b2c\u51e0\u5929:DD 01-31<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E5%B0%8F%E6%97%B6\" >\u5c0f\u65f6<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#12%E5%B0%8F%E6%97%B6%E5%88%B6%E7%9A%84_HH%E3%80%81HH12\" >12\u5c0f\u65f6\u5236\u7684:HH\u3001HH12<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#24%E5%B0%8F%E6%97%B6%E5%88%B6%E7%9A%84_HH24\" >24\u5c0f\u65f6\u5236\u7684:HH24<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E4%B8%8A%E5%8D%88%E4%B8%8B%E5%8D%88_AM%E3%80%81PM\" >\u4e0a\u5348\u4e0b\u5348:AM\u3001PM<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E5%88%86%E9%92%9F_MI\" >\u5206\u949f:MI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E7%A7%92%EF%BC%9ASS\" >\u79d2\uff1aSS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E6%AF%AB%E7%A7%92_FFn\" >\u6beb\u79d2:FF[n]<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E4%B8%96%E7%BA%AA%EF%BC%9ACC\" >\u4e16\u7eaa\uff1aCC<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E5%AD%A3%E5%BA%A6%EF%BC%9AQ\" >\u5b63\u5ea6\uff1aQ<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E5%91%A8%E6%95%B0\" >\u5468\u6570<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E4%B8%80%E6%9C%88%E9%87%8C%E7%9A%84%E5%91%A8%E6%95%B0_W\" >\u4e00\u6708\u91cc\u7684\u5468\u6570:W<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E4%B8%80%E5%B9%B4%E9%87%8C%E7%9A%84%E5%91%A8%E6%95%B0_WW%E3%80%81IW\" >\u4e00\u5e74\u91cc\u7684\u5468\u6570:WW\u3001IW<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E4%B8%80%E4%B8%AA%E6%98%9F%E6%9C%9F%E4%B8%AD%E7%9A%84%E7%AC%AC%E5%87%A0%E5%A4%A9_D\" >\u4e00\u4e2a\u661f\u671f\u4e2d\u7684\u7b2c\u51e0\u5929:D<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E5%85%A8%E9%95%BF%E9%A6%96%E5%AD%97%E6%AF%8D%E5%A4%A7%E5%86%99%E7%9A%84%E6%98%9F%E6%9C%9F%E5%87%A0%EF%BC%9ADAY%E3%80%81Day%E3%80%81day\" >\u5168\u957f\u9996\u5b57\u6bcd\u5927\u5199\u7684\u661f\u671f\u51e0\uff1aDAY\u3001Day\u3001day<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E7%BC%A9%E5%86%99%E9%A6%96%E5%AD%97%E6%AF%8D%E5%A4%A7%E5%86%99%E6%98%9F%E6%9C%9F%E5%87%A0%EF%BC%9ADY%E3%80%81Dy%E3%80%81dy\" >\u7f29\u5199\u9996\u5b57\u6bcd\u5927\u5199\u661f\u671f\u51e0\uff1aDY\u3001Dy\u3001dy<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E5%8D%88%E5%A4%9C%E5%90%8E%E7%9A%84%E7%A7%92%E6%95%B0_SSSSS\" >\u5348\u591c\u540e\u7684\u79d2\u6570:SSSSS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E5%88%A0%E9%99%A4%E5%BC%80%E5%A4%B4%E5%92%8C%E7%BB%93%E5%B0%BE%E7%9A%84%E7%A9%BA%E6%A0%BC_FM\" >\u5220\u9664\u5f00\u5934\u548c\u7ed3\u5c3e\u7684\u7a7a\u683c:FM<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E5%8F%82%E8%80%83\" >\u53c2\u8003<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E7%9B%B8%E8%BF%91%E5%8A%9F%E8%83%BD\" >\u76f8\u8fd1\u529f\u80fd<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E5%8F%8D%E5%90%91%E5%8A%9F%E8%83%BD\" >\u53cd\u5411\u529f\u80fd<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"https:\/\/www.gbase8.cn\/en\/2756\/#%E7%9B%B8%E5%85%B3%E5%8A%9F%E8%83%BD\" >\u76f8\u5173\u529f\u80fd<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%AF%AD%E6%B3%95\"><\/span>\u8bed\u6cd5<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>TO_CHAR(datetime,&#91;FORMAT])<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%AF%B4%E6%98%8E\"><\/span>\u8bf4\u660e<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u5c06\u53c2\u6570 datetime \u8f6c\u6362\u4e3a\u5b57\u7b26\u4e32\uff0c\u5e76\u8fdb\u884c\u683c\u5f0f\u5316\u8f93\u51fa\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8F%82%E6%95%B0\"><\/span>\u53c2\u6570<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u5982\u4e0b\u662f\u652f\u6301\u7684\u53c2\u6570\u5217\u8868\uff0c\u57fa\u672c\u517c\u5bb9Oracle\u7684\u5927\u90e8\u5206\u53c2\u6570\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table><tbody><tr><th>\u6a21\u677f<\/th><th>\u63cf\u8ff0<\/th><\/tr><tr><td>HH<\/td><td>\u4e00\u5929\u7684\u5c0f\u65f6\u6570 (01-12)<\/td><\/tr><tr><td>HH12<\/td><td>\u4e00\u5929\u7684\u5c0f\u65f6\u6570 (01-12)<\/td><\/tr><tr><td>HH24<\/td><td>\u4e00\u5929\u7684\u5c0f\u65f6\u6570 (00-23)<\/td><\/tr><tr><td>MI<\/td><td>\u5206\u949f (00-59)<\/td><\/tr><tr><td>SS<\/td><td>\u79d2 (00-59)<\/td><\/tr><tr><td>SSSSS<\/td><td>\u5348\u591c\u540e\u7684\u79d2 (0-86399)<\/td><\/tr><tr><td>AM or A.M. or PM or P.M.<\/td><td>\u6b63\u5348\u6807\u8bc6\uff0c\u90fd\u662f\u5927\u5199<\/td><\/tr><tr><td>Y,YYY<\/td><td>\u5e26\u9017\u53f7\u7684\u5e74\uff084 \u548c\u66f4\u591a\u4f4d\uff09<\/td><\/tr><tr><td>YYYY\u3001RRRR<\/td><td>\u5e74\uff084\u548c\u66f4\u591a\u4f4d\uff09<\/td><\/tr><tr><td>YYY<\/td><td>\u5e74\u7684\u540e\u4e09\u4f4d<\/td><\/tr><tr><td>YY\u3001RR<\/td><td>\u5e74\u7684\u540e\u4e24\u4f4d<\/td><\/tr><tr><td>Y<\/td><td>\u5e74\u7684\u6700\u540e\u4e00\u4f4d<\/td><\/tr><tr><td>BC or B.C. or AD or A.D.<\/td><td>\u5e74\u6807\u8bc6\uff0c\u90fd\u662f\u5927\u5199<\/td><\/tr><tr><td>MONTH\u3001Month\u3001month<\/td><td>\u5168\u957f\u9996\u5b57\u6bcd\u5927\u5199\u6708\u4efd\u540d<\/td><\/tr><tr><td>MON\u3001Mon\u3001mon<\/td><td>\u9996\u5b57\u6bcd\u5927\u5199\u7f29\u5199\u6708\u4efd\u540d\uff083\u5b57\u7b26\uff09<\/td><\/tr><tr><td>MM<\/td><td>\u6708\u4efd (01-12)<\/td><\/tr><tr><td>DAY\u3001Day\u3001day<\/td><td>\u5168\u957f\u9996\u5b57\u6bcd\u5927\u5199\u7684\u661f\u671f\u51e0<\/td><\/tr><tr><td>DY\u3001Dy\u3001dy<\/td><td>\u7f29\u5199\u9996\u5b57\u6bcd\u5927\u5199\u661f\u671f\u51e0\uff083\u5b57\u7b26\uff09<\/td><\/tr><tr><td>DDD<\/td><td>\u4e00\u5e74\u91cc\u7684\u65e5\u5b50(001-366)<\/td><\/tr><tr><td>DD<\/td><td>\u4e00\u4e2a\u6708\u91cc\u7684\u65e5\u5b50(01-31)<\/td><\/tr><tr><td>D<\/td><td>\u4e00\u5468\u91cc\u7684\u65e5\u5b50(1-7\uff1bSUN=1)<\/td><\/tr><tr><td>W<\/td><td>\u4e00\u4e2a\u6708\u91cc\u7684\u5468\u6570<\/td><\/tr><tr><td>IW\u3001WW<\/td><td>ISO\u4e2d\u7684\u4e00\u5e74\u7684\u7b2c\u51e0\u5468\uff081-52\/53)<\/td><\/tr><tr><td>CC<\/td><td>\u4e16\u7eaa\uff082 \u4f4d\uff09<\/td><\/tr><tr><td>Q<\/td><td>\u5b63\u5ea6<\/td><\/tr><tr><td>RM<\/td><td>\u7f57\u9a6c\u6570\u5b57\u7684\u6708\u4efd\uff08I-XII\uff1bI=JAN\uff09\uff0d\u5927\u5199<\/td><\/tr><tr><td>rm<\/td><td>\u7f57\u9a6c\u6570\u5b57\u7684\u6708\u4efd\uff08I-XII\uff1bI=JAN\uff09\uff0d\u5c0f\u5199<\/td><\/tr><tr><td>FF[n]<\/td><td>\u6beb\u79d2\uff0c\u9ed8\u8ba4\u662f6\u4f4d\u7cbe\u5ea6\uff0c1&lt;=n&lt;=9<\/td><\/tr><tr><td>FM<\/td><td>\u5220\u9664\u5f00\u5934\u548c\u7ed3\u5c3e\u7684\u7a7a\u683c<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%94%A8%E4%BE%8B\"><\/span>\u7528\u4f8b<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%B9%B4%EF%BC%9AY%E3%80%81YY%EF%BC%88RR%E3%80%81YYY%E3%80%81YYYYRRRR\"><\/span>\u5e74\uff1aY\u3001YY\uff08RR)\u3001YYY\u3001YYYY(RRRR)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p> \u5bf9\u5e941-4\u4f4d\u7684\u5e74\u4efd\u8f93\u51fa<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'Y') d;\n+------+\n| d    |\n+------+\n| 1    |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'YY') d;\n+------+\n| d    |\n+------+\n| 21   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'YYY') d;\n+------+\n| d    |\n+------+\n| 021  |\n+------+\n1 row in set (Elapsed: 00:00:00.01)\n\ngbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'YYYY') d;\n+------+\n| d    |\n+------+\n| 2021 |\n+------+\n1 row in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<p>RR\u548cRRRR\u7684\u5199\u6cd5<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-02-04 11:15:16.987654321','YYYY-MM-DD HH24:MI:SS.FF'),'RR') d;\n+------+\n| d    |\n+------+\n| 21   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-02-04 11:15:16.987654321','YYYY-MM-DD HH24:MI:SS.FF'),'RRRR') d;\n+------+\n| d    |\n+------+\n| 2021 |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%B8%A6%E9%80%97%E5%8F%B7%E7%9A%84%E5%B9%B4_YYYY\"><\/span>\u5e26\u9017\u53f7\u7684\u5e74:Y,YYY<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-02-04 11:15:16.987654321','YYYY-MM-DD HH24:MI:SS.FF'),'Y,YYY') d;\n+-------+\n| d     |\n+-------+\n| 2,021 |\n+-------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%B9%B4%E5%BA%A6%E6%A0%87%E8%AF%86_AD%E3%80%81BC\"><\/span>\u5e74\u5ea6\u6807\u8bc6:AD\u3001BC<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-02-04 11:15:16','YYYY-MM-DD HH24:MI:SS'),'B.C.') d;\n+------+\n| d    |\n+------+\n| A.D. |\n+------+\n1 row in set (Elapsed: 00:00:00.01)\n\ngbase&gt; select to_char(to_date('021-02-04 11:15:16','YYYY-MM-DD HH24:MI:SS'),'B.C.') d;\n+------+\n| d    |\n+------+\n| A.D. |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9C%88%E4%BB%BD\"><\/span>\u6708\u4efd<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%95%B0%E5%AD%97%E6%9C%88%E4%BB%BD01-12_MM\"><\/span>\u6570\u5b57\u6708\u4efd(01-12):MM<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'MM') d;\n+------+\n| d    |\n+------+\n| 01   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%85%A8%E9%95%BF%E9%A6%96%E5%AD%97%E6%AF%8D%E5%A4%A7%E5%86%99%E6%9C%88%E4%BB%BD_MONTH%E3%80%81Month%E3%80%81month\"><\/span>\u5168\u957f\u9996\u5b57\u6bcd\u5927\u5199\u6708\u4efd:MONTH\u3001Month\u3001month<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u548cOracle\u4e0d\u540c\uff0cGBase\u5168\u90e8\u4e3a\u9996\u5b57\u6bcd\u5927\u5199\u7684\u7ed3\u679c\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'MONTH') d;\n+-----------+\n| d         |\n+-----------+\n| January   |\n+-----------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt;\ngbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'Month') d;\n+-----------+\n| d         |\n+-----------+\n| January   |\n+-----------+\n1 row in set (Elapsed: 00:00:00.01)\n\ngbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'month') d;\n+-----------+\n| d         |\n+-----------+\n| January   |\n+-----------+\n1 row in set (Elapsed: 00:00:00.00)\n\n\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%BC%A9%E5%86%99%E9%A6%96%E5%AD%97%E6%AF%8D%E5%A4%A7%E5%86%99%E6%9C%88%E4%BB%BD%EF%BC%9AMON%E3%80%81Mon%E3%80%81mon\"><\/span> \u7f29\u5199\u9996\u5b57\u6bcd\u5927\u5199\u6708\u4efd\uff1aMON\u3001Mon\u3001mon<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'MON') d;\n+------+\n| d    |\n+------+\n| Jan  |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'Mon') d;\n+------+\n| d    |\n+------+\n| Jan  |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'mon') d;\n+------+\n| d    |\n+------+\n| Jan  |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%BD%97%E9%A9%AC%E6%95%B0%E5%AD%97%E7%9A%84%E6%9C%88%E4%BB%BD_RM%E3%80%81rm\"><\/span>\u7f57\u9a6c\u6570\u5b57\u7684\u6708\u4efd:RM\u3001rm<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-02-04 11:15:16','YYYY-MM-DD HH24:MI:SS'),'RM') d;\n+------+\n| d    |\n+------+\n| II   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-02-04 11:15:16','YYYY-MM-DD HH24:MI:SS'),'rm') d;\n+------+\n| d    |\n+------+\n| II   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%97%A5%E6%9C%9F\"><\/span>\u65e5\u671f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%B8%80%E5%B9%B4%E4%B8%AD%E7%9A%84%E7%AC%AC%E5%87%A0%E5%A4%A9_DDD\"><\/span>\u4e00\u5e74\u4e2d\u7684\u7b2c\u51e0\u5929:DDD<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-02-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'DDD') d;\n+------+\n| d    |\n+------+\n| 035  |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%B8%80%E4%B8%AA%E6%9C%88%E4%B8%AD%E7%9A%84%E7%AC%AC%E5%87%A0%E5%A4%A9_DD_01-31\"><\/span>\u4e00\u4e2a\u6708\u4e2d\u7684\u7b2c\u51e0\u5929:DD 01-31<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-02-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'DD') d;\n+------+\n| d    |\n+------+\n| 04   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%B0%8F%E6%97%B6\"><\/span>\u5c0f\u65f6<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"12%E5%B0%8F%E6%97%B6%E5%88%B6%E7%9A%84_HH%E3%80%81HH12\"><\/span>12\u5c0f\u65f6\u5236\u7684:HH\u3001HH12<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u8d85\u8fc712\u65f6\u4f1a\u53d8\u6210\u4e0b\u5348\uff0c\u5305\u62ec12\u65f6\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'HH') d;\n+------+\n| d    |\n+------+\n| 02   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\ngbase&gt; select to_char(to_date('2021-01-04 12:15:16','YYYY-MM-DD HH24:MI:SS'),'HH') d;\n+------+\n| d    |\n+------+\n| 12   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"24%E5%B0%8F%E6%97%B6%E5%88%B6%E7%9A%84_HH24\"><\/span>24\u5c0f\u65f6\u5236\u7684:HH24<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-01-04 12:15:16','YYYY-MM-DD HH24:MI:SS'),'HH24') d;\n+------+\n| d    |\n+------+\n| 12   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'HH24') d;\n+------+\n| d    |\n+------+\n| 14   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%B8%8A%E5%8D%88%E4%B8%8B%E5%8D%88_AM%E3%80%81PM\"><\/span>\u4e0a\u5348\u4e0b\u5348:AM\u3001PM<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-02-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'HHAM') d;\n+------+\n| d    |\n+------+\n| 02PM |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-02-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'HHPM') d;\n+------+\n| d    |\n+------+\n| 02PM |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-02-04 11:15:16','YYYY-MM-DD HH24:MI:SS'),'HHPM') d;\n+------+\n| d    |\n+------+\n| 11AM |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-02-04 11:15:16','YYYY-MM-DD HH24:MI:SS'),'HHpm') d;\n+------+\n| d    |\n+------+\n| 11AM |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-02-04 11:15:16','YYYY-MM-DD HH24:MI:SS'),'HHP.M.') d;\n+--------+\n| d      |\n+--------+\n| 11A.M. |\n+--------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-02-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'HHP.M.') d;\n+--------+\n| d      |\n+--------+\n| 02P.M. |\n+--------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%86%E9%92%9F_MI\"><\/span>\u5206\u949f:MI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'MI') d;\n+------+\n| d    |\n+------+\n| 15   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%A7%92%EF%BC%9ASS\"><\/span>\u79d2\uff1aSS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'SS') d;\n+------+\n| d    |\n+------+\n| 16   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%AF%AB%E7%A7%92_FFn\"><\/span>\u6beb\u79d2:FF[n]<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u9ed8\u8ba4\u662f6\u4f4d\u7684\u5fae\u79d2\uff0c\u53ef\u4ee5\u6307\u5b9a\u7cbe\u5ea6\u3002 1&lt;=n&lt;=9\u3002\u6ce8\u610f\u5355\u4f4d\u662f\u79d2\uff0c\u6240\u4ee50.1\u79d2\u7b49\u4e8e100\u6beb\u79d2\u30020.123456\uff0c \u7cbe\u5ea6\u5230\u4e86\u6beb\u79d2\u30026\u4f4d\u4ee5\u540e\u7684\u76ee\u524d\u53ea\u6709\u663e\u793a\u7528\u9014\uff0c\u5185\u90e8\u4e0d\u80fd\u5904\u7406\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-02-04 11:15:16','YYYY-MM-DD HH24:MI:SS'),'FF') d;\n+--------+\n| d      |\n+--------+\n| 000000 |\n+--------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-02-04 11:15:16.987654321','YYYY-MM-DD HH24:MI:SS.FF'),'FF9') d;\n+-----------+\n| d         |\n+-----------+\n| 987654000 |\n+-----------+\n1 row in set (Elapsed: 00:00:00.01)\ngbase&gt; create table td(a datetime);\nQuery OK, 0 rows affected (Elapsed: 00:00:00.17)\n\ngbase&gt; insert into td values('2021-02-04 11:15:16.987654321');\nERROR 1292 (22007): Incorrect datetime value: '2021-02-04 11:15:16.987654321' for column 'a' at row 1\ngbase&gt; insert into td values('2021-02-04 11:15:16.987654');\nQuery OK, 1 row affected (Elapsed: 00:00:00.87)\n\ngbase&gt; select * from td;\n+----------------------------+\n| a                          |\n+----------------------------+\n| 2021-02-04 11:15:16.987654 |\n+----------------------------+\n1 row in set (Elapsed: 00:00:00.01)\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%B8%96%E7%BA%AA%EF%BC%9ACC\"><\/span>\u4e16\u7eaa\uff1aCC <span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u6bd4\u598220XX\u5e74\u662f21\u4e16\u7eaa<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-02-04 11:15:16','YYYY-MM-DD HH24:MI:SS'),'CC') d;\n+------+\n| d    |\n+------+\n| 21   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%AD%A3%E5%BA%A6%EF%BC%9AQ\"><\/span>\u5b63\u5ea6\uff1aQ<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-02-04 11:15:16','YYYY-MM-DD HH24:MI:SS'),'Q') d;\n+------+\n| d    |\n+------+\n| 1    |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%91%A8%E6%95%B0\"><\/span>\u5468\u6570<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%B8%80%E6%9C%88%E9%87%8C%E7%9A%84%E5%91%A8%E6%95%B0_W\"><\/span>\u4e00\u6708\u91cc\u7684\u5468\u6570:W<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u8fd4\u56de\u6307\u5b9a\u65e5\u671f\u7684\u6708\u4efd\u91cc\uff0c\u662f\u7b2c\u51e0\u5468\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-02-04 11:15:16','YYYY-MM-DD HH24:MI:SS'),'W') d;\n+------+\n| d    |\n+------+\n| 1    |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%B8%80%E5%B9%B4%E9%87%8C%E7%9A%84%E5%91%A8%E6%95%B0_WW%E3%80%81IW\"><\/span>\u4e00\u5e74\u91cc\u7684\u5468\u6570:WW\u3001IW<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u8fd4\u56de\u6307\u5b9a\u5e74\u4efd\u91cc\u7684\u7b2c\u51e0\u5468,1-53\/53<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-02-04 11:15:16','YYYY-MM-DD HH24:MI:SS'),'WW') d;\n+------+\n| d    |\n+------+\n| 05   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\ngbase&gt; select to_char(to_date('2021-02-04 11:15:16.987654321','YYYY-MM-DD HH24:MI:SS.FF'),'IW') d;\n+------+\n| d    |\n+------+\n| 05   |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%B8%80%E4%B8%AA%E6%98%9F%E6%9C%9F%E4%B8%AD%E7%9A%84%E7%AC%AC%E5%87%A0%E5%A4%A9_D\"><\/span>\u4e00\u4e2a\u661f\u671f\u4e2d\u7684\u7b2c\u51e0\u5929:D<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u6d4b\u8bd5\u53d1\u73b0\uff0c\u548cdayofweek\u76f8\u540c\uff0c\u661f\u671f\u65e5\u662f1\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'D') d;\n+------+\n| d    |\n+------+\n| 2    |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'day') d;\n+-----------+\n| d         |\n+-----------+\n| Monday    |\n+-----------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%85%A8%E9%95%BF%E9%A6%96%E5%AD%97%E6%AF%8D%E5%A4%A7%E5%86%99%E7%9A%84%E6%98%9F%E6%9C%9F%E5%87%A0%EF%BC%9ADAY%E3%80%81Day%E3%80%81day\"><\/span>\u5168\u957f\u9996\u5b57\u6bcd\u5927\u5199\u7684\u661f\u671f\u51e0\uff1aDAY\u3001Day\u3001day<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'Day') d;\n+-----------+\n| d         |\n+-----------+\n| Monday    |\n+-----------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'DAY') d;\n+-----------+\n| d         |\n+-----------+\n| Monday    |\n+-----------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'day') d;\n+-----------+\n| d         |\n+-----------+\n| Monday    |\n+-----------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%BC%A9%E5%86%99%E9%A6%96%E5%AD%97%E6%AF%8D%E5%A4%A7%E5%86%99%E6%98%9F%E6%9C%9F%E5%87%A0%EF%BC%9ADY%E3%80%81Dy%E3%80%81dy\"><\/span>\u7f29\u5199\u9996\u5b57\u6bcd\u5927\u5199\u661f\u671f\u51e0\uff1aDY\u3001Dy\u3001dy<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'DY') d;\n+------+\n| d    |\n+------+\n| Mon  |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'Dy') d;\n+------+\n| d    |\n+------+\n| Mon  |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-01-04 14:15:16','YYYY-MM-DD HH24:MI:SS'),'dy') d;\n+------+\n| d    |\n+------+\n| Mon  |\n+------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8D%88%E5%A4%9C%E5%90%8E%E7%9A%84%E7%A7%92%E6%95%B0_SSSSS\"><\/span>\u5348\u591c\u540e\u7684\u79d2\u6570:SSSSS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-02-04 11:15:16','YYYY-MM-DD HH24:MI:SS'),'SSSSS') d;\n+-------+\n| d     |\n+-------+\n| 40516 |\n+-------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select 40516\/60 \/60;\n+--------------+\n| 40516\/60 \/60 |\n+--------------+\n|  11.25444444 |\n+--------------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%A0%E9%99%A4%E5%BC%80%E5%A4%B4%E5%92%8C%E7%BB%93%E5%B0%BE%E7%9A%84%E7%A9%BA%E6%A0%BC_FM\"><\/span>\u5220\u9664\u5f00\u5934\u548c\u7ed3\u5c3e\u7684\u7a7a\u683c:FM<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5b9e\u9645\u6d4b\u8bd5\u6ca1\u770b\u5230\u6548\u679c\uff0c\u8fd9\u4e2a\u5728\u683c\u5f0f\u5316\u6570\u5b57\u65f6\u5f88\u6709\u6548\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select to_char(to_date('2021-02-04 11:15:16.987654321','YYYY-MM-DD HH24:MI:SS.FF'),'FMMONTH') d;\n+-----------+\n| d         |\n+-----------+\n| February  |\n+-----------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt; select to_char(to_date('2021-02-04 11:15:16.987654321','YYYY-MM-DD HH24:MI:SS.FF'),'FM MONTH') d;\n+------------+\n| d          |\n+------------+\n|  February  |\n+------------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt;\ngbase&gt; select to_char(to_date('2021-02-04 11:15:16.987654321','YYYY-MM-DD HH24:MI:SS.FF'),' MONTHFM') d;\n+------------+\n| d          |\n+------------+\n|  February  |\n+------------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase&gt;\ngbase&gt;\ngbase&gt;\ngbase&gt; select to_char(to_date('2021-02-04 11:15:16.987654321','YYYY-MM-DD HH24:MI:SS.FF'),'     MONTHFM') d;\n+----------------+\n| d              |\n+----------------+\n|      February  |\n+----------------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8F%82%E8%80%83\"><\/span>\u53c2\u8003<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%9B%B8%E8%BF%91%E5%8A%9F%E8%83%BD\"><\/span>\u76f8\u8fd1\u529f\u80fd<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><a href=\"https:\/\/www.gbase8.cn\/917\">GBase 8a\u6570\u636e\u5e93\u51fd\u6570date_format\u5c06\u65e5\u671f\u683c\u5f0f\u5316\u6210\u6307\u5b9a\u683c\u5f0f\u7684\u6587\u672c<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8F%8D%E5%90%91%E5%8A%9F%E8%83%BD\"><\/span>\u53cd\u5411\u529f\u80fd<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><a href=\"https:\/\/www.gbase8.cn\/923\">GBase 8a\u6570\u636e\u5e93\u51fd\u6570str_to_date\u5c06\u6587\u672c\u6309\u6307\u5b9a\u683c\u5f0f\u8f6c\u5316\u4e3a\u65e5\u671f<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%9B%B8%E5%85%B3%E5%8A%9F%E8%83%BD\"><\/span>\u76f8\u5173\u529f\u80fd<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><a href=\"https:\/\/www.gbase8.cn\/2735\">GBase 8a\u5c06\u6570\u5b57\u8f6c\u5b57\u7b26\u4e32to_char\u51fd\u6570\u529f\u80fd\u4ecb\u7ecd\u548c\u6837\u4f8b<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.gbase8.cn\/2733\">GBase 8a\u65f6\u95f4\u8f6c\u5b57\u7b26\u4e32\u7c7b\u578b\u7684\u51e0\u79cd\u65b9\u6cd5<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5357\u5927\u901a\u7528GBase 8a\u63d0\u4f9b\u4e86to_char\u51fd\u6570\uff0c\u6309\u7167\u6307\u5b9a\u683c\u5f0f\uff0c\u5c06\u65e5\u671f\u65f6\u95f4\u8f6c\u5316\u4e3a\u5b57\u7b26\u4e32\u3002\u672c\u6587\u4ecb\u7ecd\u8be5\u51fd\u6570\u7684\u8bed\u6cd5\u548c\u4f7f\u7528\u6837\u4f8b\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[36],"class_list":["post-2756","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-36"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2756","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=2756"}],"version-history":[{"count":49,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2756\/revisions"}],"predecessor-version":[{"id":2824,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2756\/revisions\/2824"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=2756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=2756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=2756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}