TSQL: UDF som hämtar timmar och minuter ur datum

resultatet blir ex: 14:30 utifrån inmatat datum

--Select dbo.ConvertHourMinute('2005-03-01 14:30:00')
--go

CREATE   FUNCTION ConvertHourMinute
	(@CurrentDate datetime)

RETURNS varchar(5)

AS
	
BEGIN
	DECLARE @Hour AS varchar(2)
	DECLARE @Minute AS varchar(2)

	SET @Hour = DATEPART(hh, @CurrentDate)
	SET @Minute = DATEPART(n, @CurrentDate)

	if(len(@Hour)=1)
	SET @Hour = '0'+@Hour

	if(len(@Minute)=1)
	SET @Minute = '0'+@Minute
	
RETURN @Hour + ':' + @Minute

END