Saving/Storing Time Only In Datetime

Hello all,

Perhaps someone out there could enlighten me on the issue of date/time (particularly time) storage.

I am trying to get the time component to be stored in a Datetime field. I can do a Date only as follows:

INSERT INTO Test ([DateTime])VALUES(Cast(convert(char(10),GETDATE(),102) as Datetime))

I attempted the following:


INSERT INTO Test ([DateTime])VALUES(Cast(convert(char(8),GETDATE(),108) as Datetime))

But I cannot get the time component without the default date 1/1/1900 component.

If any of you gurus out there can help me out it would be very much appreciated.

Thanks!