Herkese merhaba,
Bu yazıda sizlere SQL Server’da tarih formatı çevrimleri ile ilgili bilgi vereceğim.
Aşağıda bulunan tarih formatlarını ihtiyacınıza göre kullanabilirsiniz.
YY-MM-DD
|
1 2 3 |
SELECT SUBSTRING(CONVERT(VARCHAR(10), GETDATE(), 120), 3, 8) AS [YY-MM-DD]; SELECT REPLACE(CONVERT(VARCHAR(8), GETDATE(), 11), '/', '-') AS [YY-MM-DD]; |
YYYY-MM-DD
|
1 2 3 |
SELECT CONVERT(VARCHAR(10), GETDATE(), 120) AS [YYYY-MM-DD] SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 111), '/', '-') AS [YYYY-MM-DD] |
MM/YY
|
1 2 3 |
SELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 3), 5) AS [MM/YY] SELECT SUBSTRING(CONVERT(VARCHAR(8), GETDATE(), 3), 4, 5) AS [MM/YY] |
MM/YYYY
|
1 |
SELECT RIGHT(CONVERT(VARCHAR(10), GETDATE(), 103), 7) AS [MM/YYYY] |
YY/MM
|
1 |
SELECT CONVERT(VARCHAR(5), GETDATE(), 11) AS [YY/MM] |
YYYY/MM
|
1 |
SELECT CONVERT(VARCHAR(7), GETDATE(), 111) AS [YYYY/MM] |
Month DD, YYYY
|
1 |
SELECT DATENAME(MM, GETDATE()) + RIGHT(CONVERT(VARCHAR(12), GETDATE(), 107), 9) AS [Month DD, YYYY] |
Mon YYYY
|
1 |
SELECT SUBSTRING(CONVERT(VARCHAR(11), GETDATE(), 113), 4, 8) AS [Mon YYYY] |
Month YYYY
|
1 |
SELECT DATENAME(MM, GETDATE()) + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [Month YYYY] |
DD Month
|
1 |
SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) AS [DD Month] |
Month DD
|
1 |
SELECT DATENAME(MM, GETDATE()) + ' ' + CAST(DAY(GETDATE()) AS VARCHAR(2)) AS [Month DD] |
DD Month YY
|
1 |
SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) + ' ' + RIGHT(CAST(YEAR(GETDATE()) AS VARCHAR(4)), 2) AS [DD Month YY] |
DD Month YYYY
|
1 |
SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [DD Month YYYY] |
MM-YY
|
1 2 3 |
SELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 5), 5) AS [MM-YY]; SELECT SUBSTRING(CONVERT(VARCHAR(8), GETDATE(), 5), 4, 5) AS [MM-YY]; |
MM-YYYY
|
1 |
SELECT RIGHT(CONVERT(VARCHAR(10), GETDATE(), 105), 7) AS [MM-YYYY] |
YY-MM
|
1 2 3 |
SELECT RIGHT(CONVERT(VARCHAR(7), GETDATE(), 120), 5) AS [YY-MM] SELECT SUBSTRING(CONVERT(VARCHAR(10), GETDATE(), 120), 3, 5) AS [YY-MM] |
YYYY-MM
|
1 |
SELECT CONVERT(VARCHAR(7), GETDATE(), 120) AS [YYYY-MM] |
MMDDYY
|
1 |
SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 1), '/','') AS [MMDDYY] |
MMDDYYYY
|
1 |
SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 101), '/', '') AS [MMDDYYYY] |
DDMMYY
|
1 |
SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 3), '/', '') AS [DDMMYY] |
DDMMYYYY
|
1 |
SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 103), '/','') AS [DDMMYYYY] |
Mon-YY
|
1 |
SELECT REPLACE(RIGHT(CONVERT(VARCHAR(9), GETDATE(), 6), 6), ' ', '-') AS [Mon-YY] |
Mon-YYYY
|
1 |
SELECT REPLACE(RIGHT(CONVERT(VARCHAR(11), GETDATE(), 106), 8), ' ', '-') AS [Mon-YYYY] |
DD-Mon-YY
|
1 |
SELECT REPLACE(CONVERT(VARCHAR(9), GETDATE(), 6), ' ', '-') AS [DD-Mon-YY] |
DD-Mon-YYYY
|
1 |
SELECT REPLACE(CONVERT(VARCHAR(11), GETDATE(), 106), ' ', '-') AS [DD-Mon-YYYY] |
Kendinize göre düzenleyip kullanabilirsiniz.
Herkese çalışma hayatında ve yaşamında başarılar kolaylıklar.
Yazıyı Paylaşın
Makale Özeti
Makale Adı
SQL Server’da Tarih Formatı Çevrimleri
Açıklama
SQL Server’da tarih formatı çevrimleri hakkında bilgi verildi.
Yazar
Yavuz Selim Kart
Yayınlayan
SQL Server Eğitimleri
Site Logo
