time datatype of sql server.

Question

i stored the time in sql database table using time datatype and want that time to be display in repeater control . But i gives the error when data is filled in dataset by data adapter. I uploaded the code plz help me to solve this error.

Sanjay Kumar · Answer

try this http://sqlhints.com/2014/02/23/how-to-get-time-hour-minute-second-and-millisecond-part-from-datetime-in-sql-server/

kalpana jaiswal · Answer

thank you so much.

Krishna Rajput Singh · Answer

Hello kalpana jaiswal thnaks for writing below links i hope helpful for you...:) https://msdn.microsoft.com/en-IN/library/bb677243.aspx https://msdn.microsoft.com/en-IN/library/ms186724.aspx http://www.sqlteam.com/article/using-the-time-data-type-in-sql-server-2008 http://www.w3schools.com/sql/sql_dates.asp