Store time of the day in SQL

Question

How would you store a time or time range in SQL? It won't be a datetime because it will just be let's say 4:30PM (not, January 3rd, 4:30pm). Those would be weekly, or daily meetings. The type of queries that I need are of course be for display, but also later will include complex queries such as avoiding conflicts in schedule. I'd rather pick the best datatype for that now.

I'm using MS SQL Server Express 2005.

Thanks!

Nathan

Answer 1

Personally I would find this a reason to upgrade to 2008 which has a separate time datatype.