[dba-SQLServer] What datatype to use for a Time field

Susan Harkins wrote:
> Nicely done Arthur.
>
> My next question would be -- will the date part ever be used as a date 
> component?
>
> Susan H.
>
>
>   
>> Either you want a real representation of date/time or you want an abstract
>> concept called Time. These two things are IMO quite different. Just my 
>> $.02
>> on this subject.
>>     
>
>   
I agree with Arthur here. I allways use a date time field even if only 
the time part needs to be displayed.

The other "true" time only variable would be an elapsed time or the 
difference between two date/times. I've seem to many arguments 
(elsewhere) about the semantic meaning of things to argue ;-)

Regards!
Chris Foote