SQL Server 2005 DateTime (hh: mm return only)

Question

I am working on a stored procedure that returns a column of type DateTimedatatype.

But I want to return only hh:mmwithout seconds. I use this, but it returns seconds.

 CONVERT(VARCHAR(8), tbltime.Time, 108) AS [Time]

Any ideas for removing seconds?

+5

pikk Feb 28 '12 at 12:58

2 answers

try the following:

select left(CONVERT(VARCHAR(8),getdate(),108),5)

+1

Vikram Feb 28 '12 at 13:01

Adathedev · Accepted Answer · 2012-02-28T13:01:24+0000

Just change it to convert to VARCHAR (5) instead :)

CONVERT(VARCHAR(5),tbltime.Time,108) AS [Time]