SQL Server 2005 DateTime (return only hh:mm)

问题:

I am working on a stored procedure which returns a column of DateTime datatype.

But I want to return only hh:mm with no seconds. I am using this but it returns seconds.

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

Any ideas to remove the seconds?

回答1:

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

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

回答2:

try this:

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