James,
>I need to figure out how many Tuesdays are contained
>within 1/1/2004 - 5/1/2004, and I need to come up with
>a result where I know how many of each day of the week
>is within that date range.
Supposing a table named tbl and datetime columns named d1 and d2,
something like this (not optimi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a table with session information, with a start and stop time.
I can aggregate the information, grouping it by hour or weekday.
But, when I group it by hour and weekday, I need to also show the
average usage, so I need to figure out how many Tu