How to save Only Time form DatetimePicker?

There are no separate time and date data types for storing only times or only dates. If only a time is specified when setting a datetime or smalldatetime value, the date defaults to January 1, 1900. If only a date is specified, the time defaults to 12:00 A.M. (Midnight).

You can use one of the following options:

1) What you can do is store time as string of characters using "nvarchar".

2) Define new type with underlying type as "nvarchar" and name it as "Time", length should be five, rule none and default none.

3) Format the same date which is stored in database using date functions in select statement, e.g DATEPART(dw,date).

4) Format the date in front end it self which is more easy and flexible way of doing it and then display it.

cheers.