Wiki

None

None Defined

SQL Function to Create DateTime Value

CREATE FUNCTION [dbo].[CreateDateTime] (@DATE datetime, @TIME VARCHAR(4))
RETURNS DateTime AS  
BEGIN 
DECLARE @NewTime datetime
DECLARE @HOUR INT
DECLARE @MINUTE INT
--
IF len(@TIME) = 3
      BEGIN
      SET @HOUR = CAST(LEFT(@TIME,1) AS INT)
      END
ELSE
      BEGIN
      SET @HOUR = CAST(LEFT(@TIME,2) AS INT)
      END
SET @MINUTE = CAST(RIGHT(@TIME,2) AS INT)
SET @NewTime = dateadd(hh,@HOUR, @DATE)
SET @NewTime = dateadd(n, @MINUTE, @NewTime)
RETURN @newtime
END

Solution

30 Apr 2007