[dba-SQLServer] Updating DateTime Field IN SQL Server With Just The Time

To all,

I have a little problem which I am sure this group can tell me the answer to....I have a datetime field in SQL Server 2000 I have an insert stored procedure which I pass the time to to put into the table, however it always puts the date in front of the time....I can input the time directly and no date gets put in front, I can also use a recordset with an update which works (but is slower)....Is there anyway I can insert a time into a datetime field in SQL Server 2000 without it putting the date in front using a stored procedure.

Thanks in advance for any help on this as it's driving me nuts.


Paul Hartland 
paul.hartland at fsmail.net 
07730 523179