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.
