Nov 10th, 2008, 03:31 PM
Need Advice on Data Type
I need some advice on what type of DATA TYPE I should use for SQL Server 2005.
My source data is from an excel file and I will insert the excel data into sql server.
Excel Column Names and values are:
1. ShiftStart 8:00
2. ShiftEnd 5:00
3. TimeIn 7:30
4 TimeOut 5:30
Should I use "datetime" data type for all the fields above? I really have a hard time comparing hours and minutes. Is there an easy way to compare hours and minutes?