{"id":4057,"date":"2024-03-26T15:03:03","date_gmt":"2024-03-26T07:03:03","guid":{"rendered":"http:\/\/sunlike.amtxts.com\/?p=4057"},"modified":"2025-06-26T10:29:10","modified_gmt":"2025-06-26T02:29:10","slug":"%e6%95%b8%e6%93%9a%e6%a0%bc%e5%bc%8f%e5%8c%96","status":"publish","type":"post","link":"https:\/\/www.attnerp.com.tw\/sunfusion\/?p=4057","title":{"rendered":"\u6578\u64da\u683c\u5f0f\u5316"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

<\/span>\u4e00\u3001\u5167\u5bb9\u6982\u8ff0<\/span><\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\u5728\u61c9\u7528\u4e2d\uff0c\u539f\u59cb\u7684\u6578\u64da\u683c\u5f0f\u7d93\u5e38\u4e0d\u80fd\u6eff\u8db3\u5be6\u969b\u9700\u6c42\uff0c\u9019\u6642\u5c31\u9700\u8981\u5c07\u6578\u64da\u9032\u884c\u683c\u5f0f\u5316\u8655\u7406\u4f7f\u5176\u66f4\u7b26\u5408\u9700\u8981\u3002
\u6bd4\u5982\u5716\u4e2d\u6240\u793a\uff0c\u5c07\u63a1\u8cfc\u65e5\u671f\u6539\u6210\u201c\u5e74-\u6708-\u65e5\u201d\u683c\u5f0f\uff0c\u5728\u672a\u7a05\u91d1\u984d\u524d\u9762\u52a0\u4e0a\u8ca8\u5e63\u7b26\u865f\u201c\uffe5\u201d\u4e26\u53bb\u6389\u5c0f\u6578\u9ede\u5f8c\u6578\u5b57\u3002<\/span><\/p>

\u5716\u4e2d\u7684\u683c\u5f0f\u5316\u6548\u679c\u53ef\u4ee5\u900f\u904e\u5c6c\u6027\u9762\u677f\u4e2d\u7684\u201c\u6578\u64da\u683c\u5f0f\u201d\u8a2d\u7f6e\u9805\u5be6\u73fe\uff0c\u4e5f\u53ef\u4ee5\u900f\u904e\u51fd\u6578\u904b\u7b97\u5f0f\u4f86\u5be6\u73fe\u3002
\u904b\u7b97\u5f0f\u4e2d\u5e38\u7528\u7684\u6578\u64da\u683c\u5f0f\u5316\u51fd\u6578\u6709\u5169\u500b\uff1aToString\u548cFormat\u3002<\/span><\/p>

\u63a5\u4e0b\u4f86\u6211\u5011\u5c31\u5206\u5225\u770b\u4e00\u4e0b\u5982\u4f55\u4f7f\u7528\u5c6c\u6027\u8a2d\u7f6e\u548c\u6578\u64da\u683c\u5f0f\u5316\u51fd\u6578\u5c0d\u6578\u64da\u9032\u884c\u683c\u5f0f\u5316\u8655\u7406\u3002
\"\"<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t

<\/span>\u4e8c\u3001\u5c6c\u6027\u8a2d\u7f6e\u8207\u683c\u5f0f\u5316\u51fd\u6578<\/span><\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

(1) \u65b0\u5efa\u5831\u8868\uff0c\u6dfb\u52a0\u6578\u64da\u96c6\u5f8c\uff0c\u4f7f\u7528\u8868\u683c\u5143\u4ef6\u7d81\u5b9a\u6578\u64da\u6b04\u4f4d\u3002

(2) \u70ba\u4e86\u65b9\u4fbf\u5c0d\u6bd4\u8f49\u63db\u6548\u679c\uff0c\u6211\u5011\u5728\u201c\u63a1\u8cfc\u65e5\u671f\u201d\u548c\u201c\u672a\u7a05\u91d1\u984d\u201d\u5206\u5225\u589e\u52a0\u5169\u5217\uff0c\u4e26\u7d81\u5b9a\u540c\u6a23\u7684\u6578\u64da\u6b04\u4f4d\u3002<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\"\"<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

(4) \u4f7f\u7528Format\u51fd\u6578\u6216ToString\u51fd\u6578\u9032\u884c\u6578\u64da\u683c\u5f0f\u5316\uff0c\u6bd4\u5982\u6211\u5011\u5c07\u63a1\u8cfc\u65e5\u671f\u986f\u793a\u6210\u201cyyyy\/MM\/dd\u201d\u683c\u5f0f\uff0c\u5c07\u672a\u7a05\u91d1\u984d\u986f\u793a\u6210\u8ca8\u5e63\u683c\u5f0f\u4e26\u4e14\u4e0d\u986f\u793a\u5c0f\u6578\u9ede\u5f8c\u6578\u4f4d\u3002<\/p>

\u5982\u679c\u4f7f\u7528Format\u51fd\u6578\uff0c\u5247\u904b\u7b97\u5f0f\u70ba{Format([\u8f38\u55ae\u65e5\u671f(SYS_DATE)], “yyyy\/MM\/dd”)}\u548c {Format([\u672a\u7a05\u672c\u4f4d\u5e63(AMTN)], “c0”)}\uff1b<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\"\"<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

(5) \u9810\u89bd\u5831\u8868\uff0c\u53ef\u898b\u900f\u904e\u9019\u5169\u7a2e\u65b9\u5f0f\u5c0d\u6578\u64da\u9032\u884c\u683c\u5f0f\u5316\u7684\u6548\u679c\u662f\u4e00\u81f4\u7684\u3002
\"\"<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
<\/span>\u63d0\u793a<\/span><\/h5>\n\u5f9e\u683c\u5f0f\u5316\u7684\u6b65\u9a5f\u4e2d\u53ef\u4ee5\u770b\u51fa\uff0c\u9032\u884c\u6578\u64da\u683c\u5f0f\u5316\u7684\u95dc\u9375\u5728\u65bc\u683c\u5f0f\u5316\u53c3\u6578\u7684\u8a2d\u5b9a\uff0c\u5982\u4f8b\u5b50\u4e2d\u4f7f\u7528\u4e86”yyyy\/MM\/dd”\u548c”c0″\u3002\n\n\u9664\u4e86\u9019\u5169\u500b\u4ee5\u5916\uff0c\u6211\u5011\u9084\u53ef\u4ee5\u4f7f\u7528\u4e0b\u8868\u4e2d\u66f4\u591a\u7684\u683c\u5f0f\u5316\u53c3\u6578\u3002\n\n\u6bd4\u5982\uff1a\n\nToString(\u201cn2″)\u53ef\u4ee5\u5c07\u6578\u64da\u8f49\u63db\u70ba\u5e36\u6709\u5343\u5206\u4f4d\u5143\u6a19\u8b58\u7684\u6578\u4f4d\u683c\u5f0f\uff0c\u4e26\u4e14\u5c0f\u6578\u9ede\u5f8c\u4fdd\u7559\u5169\u4f4d\u3002\u5982\u679c\u5c07n2\u6539\u70ban0\uff0c\u5247\u8868\u793a\u4e0d\u4fdd\u7559\u5c0f\u6578\u4f4d\u6578\u3002\n\nToString(\u201cp2″)\u53ef\u4ee5\u5c07\u6578\u64da\u8f49\u63db\u70ba\u767e\u5206\u6578\u683c\u5f0f\uff0c\u4e26\u4e14\u5c0f\u6578\u9ede\u5f8c\u4fdd\u7559\u5169\u4f4d\u3002\u5982\u679c\u5c07p2\u6539\u70bap0\uff0c\u5247\u8868\u793a\u4e0d\u4fdd\u7559\u5c0f\u6578\u4f4d\u6578\u3002\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\u985e\u578b<\/th>\n\u5b57\u6bcd<\/th>\n\u542b\u7fa9<\/th>\n<\/tr>\n<\/tbody>\n
\u6578\u4f4d\u985e\u578b<\/td>\n\u201cC\u201d\u6216\u201cc\u201d<\/td>\n\u8ca8\u5e63<\/td>\n<\/tr>\n
\u201cD\u201d\u6216\u201cd\u201d<\/td>\n\u6578\u503c<\/td>\n<\/tr>\n
\u201cE\u201d\u6216\u201ce\u201d<\/td>\n\u79d1\u5b78\u8a08\u6578\u6cd5<\/td>\n<\/tr>\n
\u201cF\u201d\u6216\u201cf\u201d<\/td>\n\u56fa\u5b9a\u5c0f\u6578\u9ede<\/td>\n<\/tr>\n
\u201cG\u201d\u6216\u201cg\u201d<\/td>\n\u5e38\u898f<\/td>\n<\/tr>\n
\u201cN\u201d\u6216\u201cn\u201d<\/td>\n\u6578\u5b57<\/td>\n<\/tr>\n
\u201cP\u201d\u6216\u201cp\u201d<\/td>\n\u767e\u5206\u6bd4<\/td>\n<\/tr>\n
\u201cR\u201d\u6216\u201cr\u201d<\/td>\n\u5f80\u8fd4\u904e\u7a0b<\/td>\n<\/tr>\n
\u201cX\u201d\u6216\u201cx\u201d<\/td>\n\u5341\u516d\u9032\u4f4d<\/td>\n<\/tr>\n
\u65e5\u671f\u6642\u9593\u985e\u578b<\/td>\n“d”<\/td>\n\u77ed\u65e5\u671f<\/td>\n<\/tr>\n
“D”<\/td>\n\u9577\u65e5\u671f<\/td>\n<\/tr>\n
“f”<\/td>\n\u5b8c\u6574\u65e5\u671f\/\u77ed\u6642\u9593<\/td>\n<\/tr>\n
“F”<\/td>\n\u5b8c\u6574\u65e5\u671f\/\u9577\u6642\u9593<\/td>\n<\/tr>\n
“g”<\/td>\n\u666e\u901a\u65e5\u671f\/\u77ed\u6642\u9593<\/td>\n<\/tr>\n
“G”<\/td>\n\u666e\u901a\u65e5\u671f\/\u9577\u6642\u9593<\/td>\n<\/tr>\n
“t”<\/td>\n\u77ed\u6642\u9593<\/td>\n<\/tr>\n
“T”<\/td>\n\u9577\u6642\u9593<\/td>\n<\/tr>\n
\u201cM\u201d\u6216\u201cm\u201d<\/td>\n\u6708\/\u65e5\u6a21\u5f0f<\/td>\n<\/tr>\n
\u201cO\u201d\u6216\u201co\u201d<\/td>\n\u5f80\u8fd4\u65e5\u671f<\/td>\n<\/tr>\n
\u201cR\u201d\u6216\u201cr\u201d<\/td>\nRFC1123 \u6a21\u5f0f<\/td>\n<\/tr>\n
\u201cs\u201d<\/td>\n\u53ef\u6392\u5e8f\u65e5\u671f<\/td>\n<\/tr>\n
\u201cu\u201d<\/td>\n\u901a\u7528\u53ef\u6392\u5e8f\u65e5\u671f<\/td>\n<\/tr>\n
\u201cU\u201d<\/td>\n\u901a\u7528\u5b8c\u6574\u65e5\u671f<\/td>\n<\/tr>\n
\u201cY\u201d\u6216\u201cy\u201d<\/td>\n\u5e74\u6708<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

<\/span>\u4e09\u3001\u683c\u5f0f\u5316\u51fd\u6578\u793a\u4f8b<\/span><\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\u4e00\u4e9b\u5834\u666f\u4e2d\u4e0d\u80fd\u4f7f\u7528\u5c6c\u6027\u8a2d\u7f6e\u9032\u884c\u683c\u5f0f\u5316\u8655\u7406\u6642\uff0c\u5982\u8655\u7406\u904b\u7b97\u5f0f\u4e2d\u7684\u6578\u64da\u683c\u5f0f\u6642\uff0c\u53ef\u4ee5\u4f7f\u7528\u683c\u5f0f\u5316\u51fd\u6578\u4f86\u5be6\u73fe\u3002<\/p>

\u6bd4\u5982\u6211\u5011\u9700\u8981\u70ba\u8868\u683c\u6dfb\u52a0\u4e00\u500b\u8868\u982d\uff0c\u4ee5\u7279\u5b9a\u7684\u6578\u64da\u683c\u5f0f\u4f86\u986f\u793a\u67e5\u8a62\u5831\u8868\u7684\u6642\u9593\u548c\u92b7\u552e\u7e3d\u984d\uff0c\u5982\u5716\u6240\u793a\u3002

\u6b64\u6642\u4fbf\u4e0d\u80fd\u76f4\u63a5\u900f\u904e\u5c6c\u6027\u8a2d\u7f6e\u4f86\u5be6\u73fe\u76ee\u6a19\u6548\u679c\uff0c\u53ea\u80fd\u4f7f\u7528\u683c\u5f0f\u5316\u51fd\u6578\u4fee\u6539\u904b\u7b97\u5f0f\u4e2d\u6578\u64da\u7684\u683c\u5f0f\u3002

<\/p>

\u4f7f\u7528\u7684\u904b\u7b97\u5f0f\u70ba\uff1a\u5831\u8868\u751f\u6210\u65e5\u671f\uff1a{Format(Today(), “yyyy\u5e74MM\u6708dd\u65e5”)}\uff0c\u8a02\u55ae\u7e3d\u672a\u7a05\u91d1\u984d\u70ba\uff1a
{Format(Sum([\u672a\u7a05\u672c\u4f4d\u5e63(AMTN)]), “c2”)}<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\"\"<\/a><\/p>

\"\"<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

\u4e00\u3001\u5167\u5bb9\u6982\u8ff0 \u5728\u61c9\u7528\u4e2d\uff0c\u539f\u59cb\u7684\u6578\u64da\u683c\u5f0f\u7d93\u5e38\u4e0d\u80fd\u6eff\u8db3\u5be6\u969b\u9700\u6c42\uff0c\u9019\u6642\u5c31\u9700\u8981\u5c07\u6578\u64da\u9032\u884c\u683c\u5f0f\u5316\u8655\u7406\u4f7f\u5176\u66f4\u7b26\u5408\u9700\u8981\u3002\u6bd4\u5982 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","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":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","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":[41,52,81],"tags":[],"class_list":["post-4057","post","type-post","status-publish","format-standard","hentry","category-2-","category-52","category-81"],"_links":{"self":[{"href":"https:\/\/www.attnerp.com.tw\/sunfusion\/index.php?rest_route=\/wp\/v2\/posts\/4057","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.attnerp.com.tw\/sunfusion\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.attnerp.com.tw\/sunfusion\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.attnerp.com.tw\/sunfusion\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.attnerp.com.tw\/sunfusion\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4057"}],"version-history":[{"count":27,"href":"https:\/\/www.attnerp.com.tw\/sunfusion\/index.php?rest_route=\/wp\/v2\/posts\/4057\/revisions"}],"predecessor-version":[{"id":16980,"href":"https:\/\/www.attnerp.com.tw\/sunfusion\/index.php?rest_route=\/wp\/v2\/posts\/4057\/revisions\/16980"}],"wp:attachment":[{"href":"https:\/\/www.attnerp.com.tw\/sunfusion\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.attnerp.com.tw\/sunfusion\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4057"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.attnerp.com.tw\/sunfusion\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}