On May 5, 2006, at 05:33, Jason Dodson wrote:

> 'Group By' by itself may not be sufficient. I know there are hoops
> we have to jump through here to group by a date,
> because the time is almost always different. You would need
> something like:
>
> Select (Extract(Month from MyDate) || '/' || Extract(Day from
> MyDate) || '/' || Extract(Year from MyDate)) as
> JustTheDate, count(Extract(Month from MyDate) || '/' || Extract(Day
> from MyDate) || '/' || Extract(Year from MyDate))
> From MyTable
> Group By 1

select cast(MyDate as Date), count(cast(MyDate as Date))
From MyTable
Group By 1

?
________________________________________________________
Richard Wesley Software Engineer
Tableau Software
http://www.tableausoftware.com/ hawkfish
tableausoftware com