Sql Server Tarih Formatları
SELECT CONVERT(VARCHAR, GETDATE(), 0) –Sonuç : Jul 17 2009 4:43PM
SELECT CONVERT(VARCHAR, GETDATE(), 1) –Sonuç : 07/17/09
SELECT CONVERT(VARCHAR, GETDATE(), 2) –Sonuç : 09.07.17
SELECT CONVERT(VARCHAR, GETDATE(), 3) –Sonuç : 17/07/09
SELECT CONVERT(VARCHAR, GETDATE(), 4) –Sonuç : 17.07.09
SELECT CONVERT(VARCHAR, GETDATE(), 5) –Sonuç : 17-07-09
SELECT CONVERT(VARCHAR, GETDATE(), 6) –Sonuç : 17 Jul 09
SELECT CONVERT(VARCHAR, GETDATE(), 7) –Sonuç : Jul 17, 09
SELECT CONVERT(VARCHAR, GETDATE(), 8) –Sonuç : 16:43:05
SELECT CONVERT(VARCHAR, GETDATE(), 9) –Sonuç : Jul 17 2009 4:43:05:573PM
SELECT CONVERT(VARCHAR, GETDATE(), 10) –Sonuç : 07-17-09
SELECT CONVERT(VARCHAR, GETDATE(), 11) –Sonuç : 09/07/17
SELECT CONVERT(VARCHAR, GETDATE(), 12) –Sonuç : 090717
SELECT CONVERT(VARCHAR, GETDATE(), 13) –Sonuç : 17 Jul 2009 16:43:05:590
SELECT CONVERT(VARCHAR, GETDATE(), 14) –Sonuç : 16:43:05:590
SELECT CONVERT(VARCHAR, GETDATE(), 20) –Sonuç : 2009-07-17 16:43:05
SELECT CONVERT(VARCHAR, GETDATE(), 21) –Sonuç : 2009-07-17 16:43:05.590
SELECT CONVERT(VARCHAR, GETDATE(), 22) –Sonuç : 07/17/09 4:43:05 PM
SELECT CONVERT(VARCHAR, GETDATE(), 23) –Sonuç : 2009-07-17
SELECT CONVERT(VARCHAR, GETDATE(), 24) –Sonuç : 16:43:05
SELECT CONVERT(VARCHAR, GETDATE(), 25) –Sonuç : 2009-07-17 16:43:05.590
SELECT CONVERT(VARCHAR, GETDATE(), 100) –Sonuç : Jul 17 2009 4:43PM
SELECT CONVERT(VARCHAR, GETDATE(), 101) –Sonuç : 07/17/2009
SELECT CONVERT(VARCHAR, GETDATE(), 102) –Sonuç : 2009.07.17
SELECT CONVERT(VARCHAR, GETDATE(), 103) –Sonuç : 17/07/2009
SELECT CONVERT(VARCHAR, GETDATE(), 104) –Sonuç : 17.07.2009
SELECT CONVERT(VARCHAR, GETDATE(), 105) –Sonuç : 17-07-2009
SELECT CONVERT(VARCHAR, GETDATE(), 106) –Sonuç : 17 Jul 2009
SELECT CONVERT(VARCHAR, GETDATE(), 107) –Sonuç : Jul 17, 2009
SELECT CONVERT(VARCHAR, GETDATE(), 108) –Sonuç : 16:43:05
SELECT CONVERT(VARCHAR, GETDATE(), 109) –Sonuç : Jul 17 2009 4:43:05:607PM
SELECT CONVERT(VARCHAR, GETDATE(), 110) –Sonuç : 07-17-2009
SELECT CONVERT(VARCHAR, GETDATE(), 111) –Sonuç : 2009/07/17
SELECT CONVERT(VARCHAR, GETDATE(), 112) –Sonuç : 20090717
SELECT CONVERT(VARCHAR, GETDATE(), 113) –Sonuç : 17 Jul 2009 16:43:05:607
SELECT CONVERT(VARCHAR, GETDATE(), 114) –Sonuç : 16:43:05:620
SELECT CONVERT(VARCHAR, GETDATE(), 120) –Sonuç : 2009-07-17 16:43:05
SELECT CONVERT(VARCHAR, GETDATE(), 121) –Sonuç : 2009-07-17 16:43:05.620
SELECT CONVERT(VARCHAR, GETDATE(), 126) –Sonuç : 2009-07-17T16:43:05.620
SELECT CONVERT(VARCHAR, GETDATE(), 127) –Sonuç : 2009-07-17T16:43:05.620
TARİH Formatlama | ||
Format # | Query | Örnek |
---|---|---|
1 | select convert(varchar, getdate(), 1) | 07/16/18 |
2 | select convert(varchar, getdate(), 2) | 18.07.16 |
3 | select convert(varchar, getdate(), 3) | 16/07/18 |
4 | select convert(varchar, getdate(), 4) | 16.07.18 |
5 | select convert(varchar, getdate(), 5) | 16-07-18 |
6 | select convert(varchar, getdate(), 6) | 16 Jul 18 |
7 | select convert(varchar, getdate(), 7) | Jul 16, 18 |
10 | select convert(varchar, getdate(), 10) | 07-16-18 |
11 | select convert(varchar, getdate(), 11) | 18/07/16 |
12 | select convert(varchar, getdate(), 12) | 180716 |
23 | select convert(varchar, getdate(), 23) | 2018-07-16 |
101 | select convert(varchar, getdate(), 101) | 07/16/2018 |
102 | select convert(varchar, getdate(), 102) | 2018.07.16 |
103 | select convert(varchar, getdate(), 103) | 16/07/2018 |
104 | select convert(varchar, getdate(), 104) | 16.07.2018 |
105 | select convert(varchar, getdate(), 105) | 16-07-2018 |
106 | select convert(varchar, getdate(), 106) | 16 Jul 2018 |
107 | select convert(varchar, getdate(), 107) | Jul 16, 2018 |
110 | select convert(varchar, getdate(), 110) | 07-16-2018 |
111 | select convert(varchar, getdate(), 111) | 2018/07/16 |
112 | select convert(varchar, getdate(), 112) | 20180716 |
ZAMAN ı Formatlamak | ||
8 | select convert(varchar, getdate(), 8) | 10:00:33 |
14 | select convert(varchar, getdate(), 14) | 10:00:33:113 |
24 | select convert(varchar, getdate(), 24) | 10:00:33 |
108 | select convert(varchar, getdate(), 108) | 10:00:33 |
114 | select convert(varchar, getdate(), 114) | 10:00:33:113 |
Tarih ve Zamanı Formatlamak | ||
0 | select convert(varchar, getdate(), 0) | Jul 16 2018 10:00AM |
9 | select convert(varchar, getdate(), 9) | Jul 16 2018 10:00:33:113AM |
13 | select convert(varchar, getdate(), 13) | 16 Jul 2018 10:00:33:113 |
20 | select convert(varchar, getdate(), 20) | 2018-07-16 10:00:33 |
21 | select convert(varchar, getdate(), 21) | 2018-07-16 10:00:33.113 |
22 | select convert(varchar, getdate(), 22) | 07/16/18 10:00:33 AM |
25 | select convert(varchar, getdate(), 25) | 2018-07-16 10:00:33.113 |
100 | select convert(varchar, getdate(), 100) | Jul 16 2018 10:00AM |
109 | select convert(varchar, getdate(), 109) | Jul 16 2018 10:00:33:113AM |
113 | select convert(varchar, getdate(), 113) | 16 Jul 2018 10:00:33:113 |
120 | select convert(varchar, getdate(), 120) | 2018-07-16 10:00:33 |
121 | select convert(varchar, getdate(), 121) | 2018-07-16 10:00:33.113 |
126 | select convert(varchar, getdate(), 126) | 2018-07-16T10:00:33.113 |
127 | select convert(varchar, getdate(), 127) | 2018-07-16T10:00:33.113 |
Problem Formatlamak | ||
130 | select convert(varchar, getdate(), 130) | 4 ?? ?????? 1439 10:00:33:113 |
131 | select convert(varchar, getdate(), 131) | 4/11/1439 10:00:33:113AM |
Bir Cevap Yazın