store SQL time only

I need to store in the SQL time only (as: 21:05:32) can someone please tell me the function for date/time display/formatting in SQL? I only know that this: (convert(char(10),getdate(),101)) will give me this: 30-01-2000 (display code 101), but what is the code for time only? help.

Re: store SQL time only

108 06:32 PM 5/8/2001, you wrote: I need to store in the SQL time only (as: 21:05:32) can someone please tell me the function for date/time display/formatting in SQL? I only know that this: (convert(char(10),getdate(),101)) will give me this: 30-01-2000 (display code 101), but what is the code