SELECT GETDATE()
SELECT GETUTCDATE()
SELECT SYSDATETIME()
SELECT SYSUTCDATETIME()
SELECT SYSDATETIMEOFFSET()
SELECT DAY(GETDATE())
SELECT MONTH(GETDATE())
SELECT YEAR(GETDATE())
SELECT DATENAME(month, GETDATE())
SELECT DATEADD(month, 2, '2017-7-28')
SELECT DATEADD(day, 5, '2017-7-28')
SELECT DATEADD(day, -5, '2017-7-28')
SELECT DATEDIFF(year, '2017-7-28', '2018-9-28')
SELECT DATEDIFF(month, '2017-7-28', '2018-9-28')
SELECT DATEDIFF(day, '2017-7-28', '2018-9-28')
SELECT TODATETIMEOFFSET('2017-7-28 01:10:22', '+03:00')
SELECT SWITCHOFFSET(SYSDATETIMEOFFSET(), '+02:30')
SELECT EOMONTH('2017-02-05')
SELECT EOMONTH('2017-02-05', 3)
SELECT DATEFROMPARTS(2017, 7, 28)
SELECT ISDATE('2017-07-28')
SELECT ISDATE('2017-28-07')
SELECT ISDATE('28-07-2017')
SELECT ISDATE('SQL')
CREATE TABLE Orders
(
Id INT IDENTITY PRIMARY KEY,
ProductId INT NOT NULL,
CustomerId INT NOT NULL,
CreatedAt DATE NOT NULL DEFAULT GETDATE(),
ProductCount INT DEFAULT 1,
Price MONEY NOT NULL
);
SELECT * FROM Orders
WHERE DATEDIFF(day, CreatedAt, GETDATE()) = 16