Transact SQL 101 - Lesson 07_05_SQL.txt

(0 KB) Pobierz

--Example 1
--DATEADD
SELECT DATEADD(dd, 7 '06/05/07')
SELECT DATEADD(mm, -3, '06/05/07')
SELECT modifieddate, DATEADD(yy, 2, modifieddate) FROM saleslt.address

--Also...Quarter, Hours, Minutes, Seconds...)
SELECT modifieddate, DATEADD(mi, 20, modifieddate) FROM saleslt.address

--Example 2
--DATEDIFF ( datepart , startdate , enddate )

SELECT DATEDIFF(dd, '06/05/07', '07/25/07')
SELECT DATEDIFF(dd, '07/25/07', '06/05/07')

SELECT modifieddate, DATEDIFF(dd, modifieddate, GETDATE()) 
FROM saleslt.address

--Also...Quarter, Weeks, Hours, Minutes, Seconds...)

Transact SQL 101 - Lesson 07_05_SQL.txt

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: