Re: determing number of Tuesdays within a date range

2005-04-28 Thread Peter Brawley
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

re: determing number of Tuesdays within a date range

2005-04-28 Thread James Black
-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