-
Nov 10th, 2008, 04:31 PM
#1
Thread Starter
Addicted Member
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|