How to get Time from DateTime in SQL Server

Hi nedash,

Below is the query.

SELECT CONVERT(VARCHAR(7),GETDATE(),108) [Time]

Hi nedash,

Since your datatype is Time its showing by adding :00 with the inserted value. Can't do any thing for this. Only way is you can chage the datatype to VARCHAR to insert only hour and min.

DECLARE @Test AS TABLE(T VARCHAR(5))
INSERT INTO @Test VALUES((CONVERT(VARCHAR(5),GETDATE(),108)))
SELECT * FROM @Test

  T

13:47