SQL Date Function

SQL Date Function

SELECT CURRENT_TIMESTAMP AS Result  

-- Result

-- 2019-11-23 00:27:26.280

SELECT DATEADD(day,2,'2019-11-25') AS Result  

-- Resutl

-- 2019-11-27 00:00:00.000

SELECT DATEADD(month,2,'2019-07-01') AS Result  

-- Resutl

-- 2019-11-27 00:00:00.000

SELECT DATEDIFF(day,'2018-01-01','2019-01-01') AS Result  

-- Resutl

-- 365

SELECT DATENAME(month, '2019-07-01') AS Result  

-- Resutl

-- July

SELECT DATENAME(weekday, '2019-07-01')AS Result  

-- Resutl

-- Monday

SELECT DATEPART(month, '2019-07-01')AS Result  

-- Resutl

-- 7

SELECT GETDATE()  AS Result  

-- Resutl

-- 2019-11-23 00:38:31.423

SELECT GETUTCDATE() AS Result  

-- Resutl

-- 2019-11-22 21:38:44.460

SELECT ISDATE('2019-07-01') AS Result  

-- Resutl

-- 1

SELECT ISDATE('2014-18-09') AS Result  

-- Resutl

-- 0 

SELECT DAY('2019-07-01') AS Result  

-- Resutl

-- 1 

SELECT MONTH('2019-07-01') AS Result  

-- Resutl

-- 7

SELECT YEAR('2019-07-01')AS Result  

-- Resutl

-- 2019 

--Sistem Zamanı

SELECT SYSDATETIME() 

-- Resutl

-- 2019-11-23 00:40:07.0126689 

-- DATEADD: Şuank, Tarihe 7 Gün ekleyelim.

-- Bunun için 1 hafta eklemek veya 7 gün eklemek yeterlidir.

SELECT DATEADD(DD, 7, GETDATE()) AS Result  

-- Resutl

-- 2019-11-30 00:41:30.720

SELECT DATEADD(WW, 1, GETDATE()) AS Result  

-- Resutl

-- 2019-11-30 00:41:30.720 

-- Şuanki Tarihe göre Ayın hangi günündeyiz. 

SELECT DAY(GETDATE()) AS Result  

-- Resutl

-- 2019-11-30 00:41:30.720

-- Şuanki Ayın Ilk günü

SELECT DATEADD(DD,-(DAY(GETDATE())-1),CONVERT(VARCHAR,GETDATE(),112)) AS Result  

-- Resutl

-- 2019-11-01 00:00:00.000

-- Şuanki Ayın son günü 

SELECT DATEADD(DD,-(DAY(DATEADD(MM,1,GETDATE()))),DATEADD(MM,1, CONVERT(VARCHAR,GETDATE(),112)))AS Result  

-- Resutl

-- 2019-11-30 00:00:00.000

 -- DATEDIFF: Ocak 1 2007 den bugune kadar kaç gün geçti 

SELECT DATEDIFF(DD,'20070101',GETDATE())  AS Result  

-- Resutl

-- 4709

-- Şuanki Ay 

SELECT DATENAME(MM, GETDATE())  AS Result  

-- Resutl

-- November

-- Şuanki Ay

SELECT MONTH(GETDATE())  AS Result  

-- Resutl

-- 11

-- Şuanki Yıl

SELECT YEAR(CURRENT_TIMESTAMP)  AS Result  

-- Resutl

-- 2019