time datatype of sql server.

Accepted answer

try this

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

thank you so much.

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