Date Manipulation in SQL Server 2000

SELECT [Now] = GETDATE(),
[Tomorrow] = DATEADD(DAY, 1, GETDATE()),
[Seven days FROM now] = DATEADD(DAY, 7, GETDATE()),
[Seven days FROM now 2] = DATEADD(week, 1, GETDATE()),
[One hour FROM now] = DATEADD(hour, 1, GETDATE()),
[Three hours FROM now] = DATEADD(hour, 3, GETDATE()),
[An half hour FROM now] = DATEADD(minute, 30, GETDATE()),
[10 minutes FROM now] = DATEADD(minute, 10, GETDATE()),
[30 seconds FROM now] = DATEADD(minute, 10, GETDATE()),
[Tomorrow at 12 midnight] = DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 1),
[Tomorrow at 8] = DATEADD(hour, 8, DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 1))