Whats the best way do deal with collecting a date and an hour seperately in setting the data types of the fields in MS SQL 2005. I have a web form where I need to capture both the day date ( like 3/24/2010) as well as the time ( like 4:00 PM ). The data type in SQL for the day date could be "datetime" but what about the hour? "datetime" also ? That seems the wrong way to go about this... probably thinking of this the wrong way.