SQLzoo.net

Intervals of time.

SQL Server
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.



Specific to SQL Server
Just use numbers.

Related links:

  • DATES