Inserting only time in the database

[Rajaneesh]

how will insert the time in database as
insert into table values(date, time , 'comment')

date - i'm inserting like '12-jan-2012'
time - i need to insert like '23:00'

[Monomachus]

You basically would need a time column.
Than you could insert a TimeSpan object.

Here are some examples.

http://blogs.msdn.com/b/usisvde/archive/2007/11/14/time-for-ado-net.aspx

http://msdn.microsoft.com/en-us/library/ms186724.aspx