{"id":226,"date":"2021-07-20T21:49:42","date_gmt":"2021-07-20T13:49:42","guid":{"rendered":"http:\/\/www.citerp.com.tw\/citwp2\/?p=226"},"modified":"2022-10-13T20:59:18","modified_gmt":"2022-10-13T12:59:18","slug":"sql-date2-01","status":"publish","type":"post","link":"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/20\/sql-date2-01\/","title":{"rendered":"[MS-SQL] \u897f\u5143\u65e5\u671f\u8f49\u6210\u6c11\u570b\u65e5\u671f"},"content":{"rendered":"\n

\u5c07\u897f\u5143\u65e5\u671f\u8f49\u6c11\u570b\u65e5\u671f<\/strong> 2011\/10\/05 –> 100\/10\/05<\/p>\n\n\n\n

EX: 2011\/10\/05 –> 100\/10\/05<\/p>\n\n\n\n

\nSELECT CONVERT(VARCHAR(3),CONVERT(VARCHAR(4),Chgdate,20) - 1911) + '\/' +\n           SUBSTRING(CONVERT(VARCHAR(10),Chgdate,20),6,2) + '\/' +\n           SUBSTRING(CONVERT(VARCHAR(10),Chgdate,20),9,2) \nFROM (SELECT CAST('2011\/10\/05' AS datetime) Chgdate) A    <\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u5be6\u4f5c:  <\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
 \u5404\u4f4d\u5982\u679c\u6709\u66f4\u597d\u7684\u5beb\u6cd5\uff0c\u6b61\u8fce\u7559\u8a00\u544a\u77e5  \u8b1d\u8b1d !  <\/p>\n\n\n\n
\n\n\n\n
 \ud83d\udc49[MS-SQL] While \u8ff4\u5708<\/a><\/p>\n\n\n\n
 \ud83d\udc49[MS-SQL] ALTER TABLE \u589e\u52a0\u6b04\u4f4d<\/a><\/p>\n\n\n\n\ud83d\udc47\u66f4\u591a\u6587\u7ae0\ud83d\udc47<\/span>\n\n\n
\"PHPMyAdmin<\/a><\/div>
<\/i> 2021-12-19<\/span><\/div>
PHPMyAdmin \u6559\u5b78(MySQL\u67e5\u8a62\u8cc7\u6599\u8868)<\/a><\/h3>
PHPMyAdmin \u6559\u5b78(MySQL\u67e5\u8a62\u8cc7\u6599\u8868)<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"WooCommerce<\/a><\/div>
<\/i> 2021-08-02<\/span><\/div>
WooCommerce \u5b89\u88dd\u8a2d\u5b9a<\/a><\/h3>
WooCommerce \u5916\u639b\u5b89\u88dd\uff0b\u8a2d\u7f6e<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"PHPMyAdmin<\/a><\/div>
<\/i> 2021-07-15<\/span><\/div>
PHPMyAdmin \u5b89\u88dd\u6559\u5b78<\/a><\/h3>
phpMyAdmin\u662f\u5ee3\u70ba\u6d41\u50b3\u7684\u7dda\u4e0a\u7ba1\u7406MySQL\u5957\u4ef6\u7db2\u9801\uff0c\u5c0d\u65bc MySQL \u8cc7\u6599\u5eab\u7684\u4f7f\u7528\u8005\u4f86\u8b1b\uff0c\u662f\u500b\u975e\u5e38\u65b9\u4fbf\u7684\u5957\u4ef6\u3002<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"[MS-SQL]<\/a><\/div>
<\/i> 2021-10-25<\/span><\/div>
[MS-SQL] ALTER TABLE \u522a\u9664\u6b04\u4f4d<\/a><\/h3>
\u5c0d\u5df2\u5b58\u5728\u7684\u8cc7\u6599\u8868\u522a\u9664\u4e00\u6b04\u4f4d<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"[MS-SQL]\u5b57\u4e32\u8655\u7406-\u53bb\u9664\u7a7a\u767d\"\/<\/a><\/div>
<\/i> 2022-01-07<\/span><\/div>
[MS-SQL]\u5b57\u4e32\u8655\u7406-\u53bb\u9664\u7a7a\u767d<\/a><\/h3>
[MS-SQL] \u5b57\u4e32\u53bb\u9664\u7a7a\u767d\u00a0ltrim\u3001rtrim<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"\u521d\u6b21\u4f7f\u7528SQL<\/a><\/div>
<\/i> 2023-06-06<\/span><\/div>
\u521d\u6b21\u4f7f\u7528SQL Server \u67e5\u8a62EXCEL \u7684\u8cc7\u6599\u9047\u5230\u7684\u5404\u7a2e\u554f\u984c\u5982\u4f55\u89e3\u6c7a<\/a><\/h3>
\u72c0\u6cc1: \u7576\u767c\u751fSQL Server \u5df2\u5c01\u9396\u5143\u4ef6 ‘Ad Hoc Distributed Queri … 
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"[MS-SQL]<\/a><\/div>
<\/i> 2021-10-25<\/span><\/div>
[MS-SQL] ALTER TABLE \u589e\u52a0\u6b04\u4f4d<\/a><\/h3>
TABLE \u589e\u52a0\u6b04\u4f4d<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"PHPMyAdmin<\/a><\/div>
<\/i> 2021-12-01<\/span><\/div>
PHPMyAdmin \u6559\u5b78(\u5efa\u7acbMySQL\u8cc7\u6599\u8868)<\/a><\/h3>
\u672c\u7ae0\u7bc0\u8981\u5b78\u7fd2\u5982\u4f55\u5efa\u7acbMySQL\u8cc7\u6599\u8868(table)\u3002<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"Visual<\/a><\/div>
<\/i> 2021-12-22<\/span><\/div>
Visual Studio Code (\u00a0VS Code) \u5b89\u88dd\u6559\u5b78(\u4f7f\u7528Python)<\/a><\/h3>
Visual Studio Code\uff08\u7c21\u7a31\u00a0VS Code\uff09\u662f\u4e00\u6b3e\u7531\u5fae\u8edf\u958b\u767c\u4e14\u8de8\u5e73\u53f0\u7684\u514d\u8cbb\u539f\u59cb\u78bc\u7de8\u8f2f\u5668\uff0c\u53ea\u8981\u88dd\u4e0a\u5c0d\u61c9\u8a9e\u8a00\u7684\u5ef6\u4f38\u5916\u639b\u6a21\u7d44(Extensions)\uff0c\u5373\u53ef\u8b8a\u6210IDE\u7684\u958b\u767c\u74b0\u5883\uff0c\u80fd\u8f15\u9b06\u64b0\u5bebPython\u3001Java\u3001PHP\u3001HTML\u7b49\u7a0b\u5f0f\u8a9e\u8a00\u3002<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div>
\"[MS-SQL]\u5b57\u4e32\u8655\u7406-\u5927\u5c0f\u5beb\u8f49\u63db\"\/<\/a><\/div>
<\/i> 2022-01-06<\/span><\/div>
[MS-SQL]\u5b57\u4e32\u8655\u7406-\u5927\u5c0f\u5beb\u8f49\u63db<\/a><\/h3>
MS-SQL \u5b57\u4e32\u5927\u5c0f\u5beb\u8f49\u63db\u00a0upper\u3001lower<\/div>
\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><\/div>
1<\/span>\n2<\/a>\n3<\/a>\n…<\/span>\n5<\/a>\nNext <\/span><\/a><\/div><\/div>\n\n\n\n