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