title: Castle ActiveRecord - can I use the SQL Server 2008 "time" data type?
body: <p>I'm working on a project where I need to track times, such as "2:15 PM" without dates.  I'm using Castle ActiveRecord.  Is there a way I can specify using the Castle attributes that I want my field to be a time data type in SQL Server 2008?  And if so, what .NET type would I make the field?  DateTime?</p>
  
  <p>In addition, I may need to attach time zones to these times.  What's the best way to do this using Castle ActiveRecord and SQL Server 2008?</p>