DATEADD

Sanaga bir yil qo‘shing, so‘ng sanani qaytaring:

SELECT DATEADD(year, 1, '2017/08/25') AS DateAdd;

Ta’rif va qo‘llanilishi

DATEADD() funksiyasi sanaga vaqt/sana oralig‘ini qo‘shadi va hosil bo‘lgan sanani qaytaradi.

DATEADD(interval, number, date)

Parametr	Tavsif
interval	Required. The time/date interval to add. Can be one of the following values: year, yyyy, yy = Year quarter, qq, q = Quarter month, mm, m = month dayofyear, dy, y = Yilning kuni day, dd, d = Day week, ww, wk = Week weekday, dw, w = Weekday hour, hh = hour minute, mi, n = Minute second, ss, s = Second millisecond, ms = Millisecond
number	Majburiy. Sanaga qo‘shiladigan interval soni. Musbat (kelajakdagi sanalarni olish uchun) yoki manfiy (o‘tmishdagi sanalarni olish uchun) bo‘lishi mumkin
date	Majburiy. O‘zgartiriladigan sana

Qo‘llab-quvvatlaydigan tizimlar:	SQL Server (2008 dan boshlab), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

Sanaga ikki oy qo‘shing, so‘ng sanani qaytaring:

SELECT DATEADD(month, 2, '2017/08/25') AS DateAdd;

Sanadan ikki oy ayiring, so‘ng sanani qaytaring:

SELECT DATEADD(month, -2, '2017/08/25') AS DateAdd;

Tug‘ilgan sana ustunidagi sanaga 18 yil qo‘shing, keyin sanani qaytaring:

SELECT LastName, BirthDate, DATEADD(year, 18, BirthDate) AS DateAdd FROM Employees;

Yutuqlaringizni kuzating – bu bepul!