I am trying to group on a datetime field in a sql server table.

In fox I would say "group by ttod(mydatetimefield)..."

SQL Server does not seem to have these great datetime conversion functions.

Suggestions on how to do this?

Thanks,
Terrence