Skip to content

ch1.md

Latest commit

 

History

History
19 lines (14 loc) · 326 Bytes

ch1.md

File metadata and controls

19 lines (14 loc) · 326 Bytes

SQL Tutorial: Functions

Chapter 1: Date Functions

-- The day after tomorrow
SELECT DATEADD(DAY, 2, GETDATE())

-- Next year
SELECT DATEADD(YEAR, 1, GETDATE())

-- 48 Hours
SELECT DATEDIFF(HOUR, '2015-07-11', '2015-07-13')

-- July
SELECT DATENAME(MONTH, '2015-07-11')

-- 7
SELECT DATEPART(MONTH, '2015-07-11')