HOW TO REMOVE DATE FROM DATETIME FIELD IN SQL SERVER — USE CONVERT

SELECT CONVERT ( VARCHAR(10) , GETDATE() , 108 ) AS ‘TIME’

OUTPUT
__________________

14:39:32

Happy Programming.

Pawan Kumar
Pawankkmr@hotmail.com