An Alternative:

ALTER FUNCTION [dbo].[GetDateTimeString]

(

@inDateTime datetime

)

RETURNS varchar(12)

AS

BEGIN

DECLARE @DateString varchar(12), @Hours varchar(2), @Minutes varchar(2)

SELECT@Hours = CONVERT(varchar(2), DATEPART(hour, @inDateTime)),

@Minutes = CONVERT(varchar(2), DATEPART(minute, @inDateTime)),

@DateString = CONVERT(varchar(8), @inDateTime, 112) +

STUFF('00', 3 - LEN(@Hours), 2, @Hours) +

STUFF('00', 3 - LEN(@Minutes), 2, @Minutes)

RETURN @DateString

END