how to get time part from datetime in sql server
Anand N
select convert(varchar(15),getdate(),114)
SELECT CONVERT(VARCHAR(8),GETDATE(),108) AS HourMinuteSec