How do I store time and get time only.

if you need to store only time then you can store in Time data type, if your sql server version is older and not supporting time date type, then you can store in datetime and get only time in select query or also can store in varchar or nvarchar type.

and for getting time from c# code you can use like this...

string time = DateTime.Now.ToString("hh:mm:ss t");
string time = DateTime.Now.ToString("HH:mm:ss"); //for geting time in 24 hrs format

try with this code. Store time in database as nvarchar

TimeSpan timespan = new TimeSpan(03,00,00);
DateTime time = DateTime.Today.Add(timespan);
string displayTime = date.ToString("hh:mm tt");

In C# you can do like :

TimeSpan dt = DateTime.Now.TimeOfDay;
           Console.WriteLine(dt);

And in SQl Server you can do like:

declare  @timetable table
(
	UserTime Time
)

insert  into @timetable values('02:24:56.180')

SELECT * FROM @timetable

if you want to store time as timespan. Try This

DateTime dt = DateTime.Parse(Datetime.Now.ToString("hh:mm tt"));
TimeSpan ts = new TimeSpan(dt.Hour, dt.Minute, dt.Second);