Convert Datetime to String in Sql Server

崬城衞

Convert Datetime to String in Sql Server
　　

0 [td]Feb 22 2006 4:26PM [td]CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0)[/td]

1 [td]02/22/06 [td]CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1)[/td]

2 [td]06.02.22 [td]CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2)[/td]

3 [td]22/02/06 [td]CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3)[/td]

4 [td]22.02.06 [td]CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4)[/td]

5 [td]22-02-06 [td]CONVERT(CHAR(8), CURRENT_TIMESTAMP, 5)[/td]

6 [td]22 Feb 06 [td]CONVERT(CHAR(9), CURRENT_TIMESTAMP, 6)[/td]

7 [td]Feb 22, 06 [td]CONVERT(CHAR(10), CURRENT_TIMESTAMP, 7)[/td]

8 [td]16:26:08 [td]CONVERT(CHAR(8), CURRENT_TIMESTAMP, 8)[/td]

9 [td]Feb 22 2006 4:26:08:020PM [td]CONVERT(CHAR(26), CURRENT_TIMESTAMP, 9)[/td]

10 [td]02-22-06 [td]CONVERT(CHAR(8), CURRENT_TIMESTAMP, 10)[/td]

11 [td]06/02/22 [td]CONVERT(CHAR(8), CURRENT_TIMESTAMP, 11)[/td]

12 [td]060222 [td]CONVERT(CHAR(6), CURRENT_TIMESTAMP, 12)[/td]

13 [td]22 Feb 2006 16:26:08:020 [td]CONVERT(CHAR(24), CURRENT_TIMESTAMP, 13)[/td]

14 [td]16:26:08:037 [td]CONVERT(CHAR(12), CURRENT_TIMESTAMP, 14)[/td]

20 [td]2006-02-22 16:26:08 [td]CONVERT(CHAR(19), CURRENT_TIMESTAMP, 20)[/td]

21 [td]2006-02-22 16:26:08.037 [td]CONVERT(CHAR(23), CURRENT_TIMESTAMP, 21)[/td]

22 [td]02/22/06 4:26:08 PM [td]CONVERT(CHAR(20), CURRENT_TIMESTAMP, 22)[/td]

23 [td]2006-02-22 [td]CONVERT(CHAR(10), CURRENT_TIMESTAMP, 23)[/td]

24 [td]16:26:08 [td]CONVERT(CHAR(8), CURRENT_TIMESTAMP, 24)[/td]

25 [td]2006-02-22 16:26:08.037 [td]CONVERT(CHAR(23), CURRENT_TIMESTAMP, 25)[/td]

100 [td]Feb 22 2006 4:26PM [td]CONVERT(CHAR(19), CURRENT_TIMESTAMP, 100)[/td]

101 [td]02/22/2006 [td]CONVERT(CHAR(10), CURRENT_TIMESTAMP, 101)[/td]

102 [td]2006.02.22 [td]CONVERT(CHAR(10), CURRENT_TIMESTAMP, 102)[/td]

103 [td]22/02/2006 [td]CONVERT(CHAR(10), CURRENT_TIMESTAMP, 103)[/td]

104 [td]22.02.2006 [td]CONVERT(CHAR(10), CURRENT_TIMESTAMP, 104)[/td]

105 [td]22-02-2006 [td]CONVERT(CHAR(10), CURRENT_TIMESTAMP, 105)[/td]

106 [td]22 Feb 2006 [td]CONVERT(CHAR(11), CURRENT_TIMESTAMP, 106)[/td]

107 [td]Feb 22, 2006 [td]CONVERT(CHAR(12), CURRENT_TIMESTAMP, 107)[/td]

108 [td]16:26:08 [td]CONVERT(CHAR(8), CURRENT_TIMESTAMP, 108)[/td]

109 [td]Feb 22 2006 4:26:08:067PM [td]CONVERT(CHAR(26), CURRENT_TIMESTAMP, 109)[/td]

110 [td]02-22-2006 [td]CONVERT(CHAR(10), CURRENT_TIMESTAMP, 110)[/td]

111 [td]2006/02/22 [td]CONVERT(CHAR(10), CURRENT_TIMESTAMP, 111)[/td]

112 [td]20060222 [td]CONVERT(CHAR(8), CURRENT_TIMESTAMP, 112)[/td]

113 [td]22 Feb 2006 16:26:08:067 [td]CONVERT(CHAR(24), CURRENT_TIMESTAMP, 113)[/td]

114 [td]16:26:08:067 [td]CONVERT(CHAR(12), CURRENT_TIMESTAMP, 114)[/td]

120 [td]2006-02-22 16:26:08 [td]CONVERT(CHAR(19), CURRENT_TIMESTAMP, 120)[/td]

121 [td]2006-02-22 16:26:08.080 [td]CONVERT(CHAR(23), CURRENT_TIMESTAMP, 121)[/td]

126 [td]2006-02-22T16:26:08.080 [td]CONVERT(CHAR(23), CURRENT_TIMESTAMP, 126)[/td]

127 [td]2006-02-22T16:26:08.080 [td]CONVERT(CHAR(23), CURRENT_TIMESTAMP, 127)[/td]

130 [td]24 ???? 1427 4:26:08:080PM [td]CONVERT(CHAR(32), CURRENT_TIMESTAMP, 130)[/td]

131 [td]24/01/1427 4:26:08:080PM [td]CONVERT(CHAR(25), CURRENT_TIMESTAMP, 131)