ronmoses (11/20/2009)

---

daniel.gardiner (11/20/2009)

---

I answered correctly but didn't get the point, the answer page tells me that the correct selection is '1' because 'Joe' is the only match (which is the...

I answered correctly but didn't get the point, the answer page tells me that the correct selection is '1' because 'Joe' is the only match (which is the fourth selection...

I would consider them the "same" if I could use either one in my code and receive the same results. However, queries like the following:

select datediff(hh, '2009-11-17 7:57:00', GETDATE())

select...

I don't define 'week', that's determined by SQL, and a quick Google search shows that the first day of the week can be changed with SET DATEFIRST. The original...

I'm not certain of the SQL functions but is it possible to:

subtract 7 days from the current date

determine the 'week' part of this date

select records with dates from this 'week'