SQL Server Date Functions • select getdate() • select SYSDATETIME() • select DATEADD(year,2,getdate()) • select DATEDIFF(day,'2022-04-03','2022-04-06') • select DATEFROMPARTS(2018,04,03) • select datename(month,'2022-04-03') • select datepart(month,'2022-04-03') • select month('2022-04-03') • select ISDATE('2022-04-03') • select ISDATE('fff')
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.