SQL’de Tarih Saat Görünümünün Farklı Formatta Görüntülenmesi
SQL'de tarih saat görünümü sorgulara aşağıdaki ilgili değer verilerek istenen formatın görünümü sağlanabilir.
|
DEĞER |
SORGU |
Tarih Formatı |
|
1 |
select convert(varchar, getdate(), 1) |
12/30/06 |
|
2 |
select convert(varchar, getdate(), 2) |
06.12.30 |
|
3 |
select convert(varchar, getdate(), 3) |
30/12/06 |
|
4 |
select convert(varchar, getdate(), 4) |
30.12.06 |
|
5 |
select convert(varchar, getdate(), 5) |
30-12-06 |
|
6 |
select convert(varchar, getdate(), 6) |
30 Dec 06 |
|
7 |
select convert(varchar, getdate(), 7) |
Dec 30, 06 |
|
10 |
select convert(varchar, getdate(), 10) |
12-30-06 |
|
11 |
select convert(varchar, getdate(), 11) |
06/12/30 |
|
12 |
select convert(varchar, getdate(), 12) |
061230 |
|
23 |
select convert(varchar, getdate(), 23) |
2006-12-30 |
|
101 |
select convert(varchar, getdate(), 101) |
12/30/2006 |
|
102 |
select convert(varchar, getdate(), 102) |
2006.12.30 |
|
103 |
select convert(varchar, getdate(), 103) |
30/12/2006 |
|
104 |
select convert(varchar, getdate(), 104) |
30.12.2006 |
|
105 |
select convert(varchar, getdate(), 105) |
30-12-2006 |
|
106 |
select convert(varchar, getdate(), 106) |
30 Dec 2006 |
|
107 |
select convert(varchar, getdate(), 107) |
Dec 30, 2006 |
|
110 |
select convert(varchar, getdate(), 110) |
12-30-2006 |
|
111 |
select convert(varchar, getdate(), 111) |
2006/12/30 |
|
112 |
select convert(varchar, getdate(), 112) |
20061230 |
|
8 |
select convert(varchar, getdate(), 8) |
00:38:54 |
|
14 |
select convert(varchar, getdate(), 14) |
00:38:54:840 |
|
24 |
select convert(varchar, getdate(), 24) |
00:38:54 |
|
108 |
select convert(varchar, getdate(), 108) |
00:38:54 |
|
114 |
select convert(varchar, getdate(), 114) |
00:38:54:840 |
|
0 |
select convert(varchar, getdate(), 0) |
Dec 12 2006 12:38AM |
|
9 |
select convert(varchar, getdate(), 9) |
Dec 30 2006 12:38:54:840AM |
|
13 |
select convert(varchar, getdate(), 13) |
30 Dec 2006 00:38:54:840AM |
|
20 |
select convert(varchar, getdate(), 20) |
2006-12-30 00:38:54 |
|
21 |
select convert(varchar, getdate(), 21) |
2006-12-30 00:38:54.840 |
|
22 |
select convert(varchar, getdate(), 22) |
12/30/06 12:38:54 AM |
|
25 |
select convert(varchar, getdate(), 25) |
2006-12-30 00:38:54.840 |
|
100 |
select convert(varchar, getdate(), 100) |
Dec 30 2006 12:38AM |
|
109 |
select convert(varchar, getdate(), 109) |
Dec 30 2006 12:38:54:840AM |
|
113 |
select convert(varchar, getdate(), 113) |
30 Dec 2006 00:38:54:840 |
|
120 |
select convert(varchar, getdate(), 120) |
2006-12-30 00:38:54 |
|
121 |
select convert(varchar, getdate(), 121) |
2006-12-30 00:38:54.840 |
|
126 |
select convert(varchar, getdate(), 126) |
2006-12-30T00:38:54.840 |
|
127 |
select convert(varchar, getdate(), 127) |
2006-12-30T00:38:54.840 |
|
130 |
select convert(nvarchar, getdate(), 130) |
|
|
131 |
select convert(nvarchar, getdate(), 131) |
10/12/1427 12:38:54:840AM |
