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");