INTERVAL of time

Intervals of time.

schema:gisq

We can add (or subtract) a number of days (or years, months, hours, minutes or seconds) from date.

In this example we want to find the totp events that went out in the week of my 14th birthday.

SELECT * FROM totp
WHERE '1976-05-20'
 BETWEEN wk - 7 DAY
     AND wk

SELECT * FROM totp
WHERE #1976-05-20#
 BETWEEN wk - 7 
     AND wk

SELECT * FROM totp
WHERE '1976-05-20'
 BETWEEN DATEADD(DAY,-7,wk)
     AND wk

SELECT * FROM totp
WHERE '1976-05-20'
 BETWEEN wk - 7
     AND wk

SELECT * FROM totp
WHERE '1976-05-20'
 BETWEEN DATE(wk, '-7 days')
     AND wk

SELECT * FROM totp
WHERE DATE '1976-05-20'
 BETWEEN wk - INTERVAL '7' DAY
     AND wk

Anonymous