SQL Server 日期转换到字符串

我会带着你远行 2021-11-16 21:44 358阅读 0赞

<table> 
 <tbody> 
 <tr> 
 <td> 0 </td> 
 <td> Feb 22 2006 4:26PM </td> 
 <td> CONVERT(CHAR(19), &nbsp; CURRENT_TIMESTAMP, 0) </td> 
 </tr> 
 <tr> 
 <td> 1 </td> 
 <td> 02/22/06 </td> 
 <td> CONVERT(CHAR(8), &nbsp; CURRENT_TIMESTAMP, 1) </td> 
 </tr> 
 <tr> 
 <td> 2 </td> 
 <td> 06.02.22 </td> 
 <td> CONVERT(CHAR(8), &nbsp; CURRENT_TIMESTAMP, 2) </td> 
 </tr> 
 <tr> 
 <td> 3 </td> 
 <td> 22/02/06 </td> 
 <td> CONVERT(CHAR(8), &nbsp; CURRENT_TIMESTAMP, 3) </td> 
 </tr> 
 <tr> 
 <td> 4 </td> 
 <td> 22.02.06 </td> 
 <td> CONVERT(CHAR(8), &nbsp; CURRENT_TIMESTAMP, 4) </td> 
 </tr> 
 <tr> 
 <td> 5 </td> 
 <td> 22-02-06 </td> 
 <td> CONVERT(CHAR(8), &nbsp; CURRENT_TIMESTAMP, 5) </td> 
 </tr> 
 <tr> 
 <td> 6 </td> 
 <td> 22 Feb 06 </td> 
 <td> CONVERT(CHAR(9), &nbsp; CURRENT_TIMESTAMP, 6) </td> 
 </tr> 
 <tr> 
 <td> 7 </td> 
 <td> Feb 22, 06 </td> 
 <td> CONVERT(CHAR(10), &nbsp; CURRENT_TIMESTAMP, 7) </td> 
 </tr> 
 <tr> 
 <td> 8 </td> 
 <td> 16:26:08 </td> 
 <td> CONVERT(CHAR(8), &nbsp; CURRENT_TIMESTAMP, 8) </td> 
 </tr> 
 <tr> 
 <td> 9 </td> 
 <td> Feb 22 2006 &nbsp; 4:26:08:020PM </td> 
 <td> CONVERT(CHAR(26), &nbsp; CURRENT_TIMESTAMP, 9) </td> 
 </tr> 
 <tr> 
 <td> 10 </td> 
 <td> 02-22-06 </td> 
 <td> CONVERT(CHAR(8), &nbsp; CURRENT_TIMESTAMP, 10) </td> 
 </tr> 
 <tr> 
 <td> 11 </td> 
 <td> 06/02/22 </td> 
 <td> CONVERT(CHAR(8), &nbsp; CURRENT_TIMESTAMP, 11) </td> 
 </tr> 
 <tr> 
 <td> 12 </td> 
 <td> 060222 </td> 
 <td> CONVERT(CHAR(6), &nbsp; CURRENT_TIMESTAMP, 12) </td> 
 </tr> 
 <tr> 
 <td> 13 </td> 
 <td> 22 Feb 2006 &nbsp; 16:26:08:020 </td> 
 <td> CONVERT(CHAR(24), CURRENT_TIMESTAMP, 13) </td> 
 </tr> 
 <tr> 
 <td> 14 </td> 
 <td> 16:26:08:037 </td> 
 <td> CONVERT(CHAR(12), &nbsp; CURRENT_TIMESTAMP, 14) </td> 
 </tr> 
 <tr> 
 <td> 20 </td> 
 <td> 2006-02-22 16:26:08 </td> 
 <td> CONVERT(CHAR(19), &nbsp; CURRENT_TIMESTAMP, 20) </td> 
 </tr> 
 <tr> 
 <td> 21 </td> 
 <td> 2006-02-22 &nbsp; 16:26:08.037 </td> 
 <td> CONVERT(CHAR(23), &nbsp; CURRENT_TIMESTAMP, 21) </td> 
 </tr> 
 <tr> 
 <td> 22 </td> 
 <td> 02/22/06 4:26:08 PM </td> 
 <td> CONVERT(CHAR(20), &nbsp; CURRENT_TIMESTAMP, 22) </td> 
 </tr> 
 <tr> 
 <td> 23 </td> 
 <td> 2006-02-22 </td> 
 <td> CONVERT(CHAR(10), &nbsp; CURRENT_TIMESTAMP, 23) </td> 
 </tr> 
 <tr> 
 <td> 24 </td> 
 <td> 16:26:08 </td> 
 <td> CONVERT(CHAR(8), &nbsp; CURRENT_TIMESTAMP, 24) </td> 
 </tr> 
 <tr> 
 <td> 25 </td> 
 <td> 2006-02-22 &nbsp; 16:26:08.037 </td> 
 <td> CONVERT(CHAR(23), &nbsp; CURRENT_TIMESTAMP, 25) </td> 
 </tr> 
 <tr> 
 <td> 100 </td> 
 <td> Feb 22 2006 4:26PM </td> 
 <td> CONVERT(CHAR(19), CURRENT_TIMESTAMP, 100) </td> 
 </tr> 
 <tr> 
 <td> 101 </td> 
 <td> 02/22/2006 </td> 
 <td> CONVERT(CHAR(10), &nbsp; CURRENT_TIMESTAMP, 101) </td> 
 </tr> 
 <tr> 
 <td> 102 </td> 
 <td> 2006.02.22 </td> 
 <td> CONVERT(CHAR(10), &nbsp; CURRENT_TIMESTAMP, 102) </td> 
 </tr> 
 <tr> 
 <td> 103 </td> 
 <td> 22/02/2006 </td> 
 <td> CONVERT(CHAR(10), &nbsp; CURRENT_TIMESTAMP, 103) </td> 
 </tr> 
 <tr> 
 <td> 104 </td> 
 <td> 22.02.2006 </td> 
 <td> CONVERT(CHAR(10), &nbsp; CURRENT_TIMESTAMP, 104) </td> 
 </tr> 
 <tr> 
 <td> 105 </td> 
 <td> 22-02-2006 </td> 
 <td> CONVERT(CHAR(10), &nbsp; CURRENT_TIMESTAMP, 105) </td> 
 </tr> 
 <tr> 
 <td> 106 </td> 
 <td> 22 Feb 2006 </td> 
 <td> CONVERT(CHAR(11), &nbsp; CURRENT_TIMESTAMP, 106) </td> 
 </tr> 
 <tr> 
 <td> 107 </td> 
 <td> Feb 22, 2006 </td> 
 <td> CONVERT(CHAR(12), &nbsp; CURRENT_TIMESTAMP, 107) </td> 
 </tr> 
 <tr> 
 <td> 108 </td> 
 <td> 16:26:08 </td> 
 <td> CONVERT(CHAR(8), &nbsp; CURRENT_TIMESTAMP, 108) </td> 
 </tr> 
 <tr> 
 <td> 109 </td> 
 <td> Feb 22 2006 &nbsp; 4:26:08:067PM </td> 
 <td> CONVERT(CHAR(26), &nbsp; CURRENT_TIMESTAMP, 109) </td> 
 </tr> 
 <tr> 
 <td> 110 </td> 
 <td> 02-22-2006 </td> 
 <td> CONVERT(CHAR(10), &nbsp; CURRENT_TIMESTAMP, 110) </td> 
 </tr> 
 <tr> 
 <td> 111 </td> 
 <td> 2006/02/22 </td> 
 <td> CONVERT(CHAR(10), &nbsp; CURRENT_TIMESTAMP, 111) </td> 
 </tr> 
 <tr> 
 <td> 112 </td> 
 <td> 20060222 </td> 
 <td> CONVERT(CHAR(8), &nbsp; CURRENT_TIMESTAMP, 112) </td> 
 </tr> 
 <tr> 
 <td> 113 </td> 
 <td> 22 Feb 2006 &nbsp; 16:26:08:067 </td> 
 <td> CONVERT(CHAR(24), &nbsp; CURRENT_TIMESTAMP, 113) </td> 
 </tr> 
 <tr> 
 <td> 114 </td> 
 <td> 16:26:08:067 </td> 
 <td> CONVERT(CHAR(12), &nbsp; CURRENT_TIMESTAMP, 114) </td> 
 </tr> 
 <tr> 
 <td> 120 </td> 
 <td> 2006-02-22 16:26:08 </td> 
 <td> CONVERT(CHAR(19), &nbsp; CURRENT_TIMESTAMP, 120) </td> 
 </tr> 
 <tr> 
 <td> 121 </td> 
 <td> 2006-02-22 &nbsp; 16:26:08.080 </td> 
 <td> CONVERT(CHAR(23), &nbsp; CURRENT_TIMESTAMP, 121) </td> 
 </tr> 
 <tr> 
 <td> 126 </td> 
 <td> 2006-02-22T16:26:08.080 &nbsp; </td> 
 <td> CONVERT(CHAR(23), &nbsp; CURRENT_TIMESTAMP, 126) </td> 
 </tr> 
 <tr> 
 <td> 127 </td> 
 <td> 2006-02-22T16:26:08.080 &nbsp; </td> 
 <td> CONVERT(CHAR(23), &nbsp; CURRENT_TIMESTAMP, 127) </td> 
 </tr> 
 <tr> 
 <td> 130 </td> 
 <td> 24 ???? 1427 &nbsp; 4:26:08:080PM </td> 
 <td> CONVERT(CHAR(32), &nbsp; CURRENT_TIMESTAMP, 130) </td> 
 </tr> 
 <tr> 
 <td> 131 </td> 
 <td> 24/01/1427 &nbsp; 4:26:08:080PM </td> 
 <td> CONVERT(CHAR(25), &nbsp; CURRENT_TIMESTAMP, 131) </td> 
 </tr> 
 </tbody> 
</table>

转载于:https://www.cnblogs.com/EllieSoft/p/4807082.html