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 ...