You haven't mentioned which database server you are using. If it's SQL Server 2008 or above, you got time
] as a new datatype. (Note: I am just considered SQL Server here. Oracle and other db may also support this out of the box).
If you using old versions of SQL, you can either store them in DateTime
] or varchar to store the time. But you will need to extract the time part (either on db side or your .net code) while using it.
Hope it helps!