0 select convert(varchar, getdate(), 0) Dec 12 2020 12:38AM
1 select convert(varchar, getdate(), 1) 12/30/20
2 select convert(varchar, getdate(), 2) 20.12.30
3 select convert(varchar, getdate(), 3) 30/12/20
4 select convert(varchar, getdate(), 4) 30.12.20
5 select convert(varchar, getdate(), 5) 30-12-20
6 select convert(varchar, getdate(), 6) 30 Dec 20
7 select convert(varchar, getdate(), 7) Dec 30, 20
9 select convert(varchar, getdate(), 9) Dec 30 2020 12:38:54:840AM
10 select convert(varchar, getdate(), 10) 12-30-20
11 select convert(varchar, getdate(), 11) 20/12/30
12 select convert(varchar, getdate(), 12) 201230
13 select convert(varchar, getdate(), 13) 30 Dec 2020 00:38:54:840AM
20 select convert(varchar, getdate(), 20) 2020-12-30 00:38:54
21 select convert(varchar, getdate(), 21) 2020-12-30 00:38:54.840
22 select convert(varchar, getdate(), 22) 12/30/20 12:38:54 AM
23 select convert(varchar, getdate(), 23) 2020-12-30
25 select convert(varchar, getdate(), 25) 2020-12-30 00:38:54.840
100 select convert(varchar, getdate(), 100) Dec 30 2020 12:38AM
101 select convert(varchar, getdate(), 101) 12/30/2020
102 select convert(varchar, getdate(), 102) 2020.12.30
103 select convert(varchar, getdate(), 103) 30/12/2020
104 select convert(varchar, getdate(), 104) 30.12.2020
105 select convert(varchar, getdate(), 105) 30-12-2020
106 select convert(varchar, getdate(), 106) 30 Dec 2020
107 select convert(varchar, getdate(), 107) Dec 30, 2020
109 select convert(varchar, getdate(), 109) Dec 30 2020 12:38:54:840AM
110 select convert(varchar, getdate(), 110) 12-30-2020
111 select convert(varchar, getdate(), 111) 2020/12/30
112 select convert(varchar, getdate(), 112) 20201230
113 select convert(varchar, getdate(), 113) 30 Dec 2020 00:38:54:840
120 select convert(varchar, getdate(), 120) 2020-12-30 00:38:54
121 select convert(varchar, getdate(), 121) 2020-12-30 00:38:54.840
126 select convert(varchar, getdate(), 126) 2020-12-30T00:38:54.840
127 select convert(varchar, getdate(), 127) 2020-12-30T00:38:54.840
コメント
コメントを投稿