Technical Article

DateTime to hh:mm:ss

,

a function to convert a date time value what ever it is to hh:mm:ss format.

CREATE FUNCTION BP_Select_HHMMSS(@DateTime DATETIME)
RETURNS VARCHAR(50)
AS
BEGIN

DECLARE @RetVal VARCHAR(50)

DECLARE @hh varchar(3),@mi varchar(3),@ss varchar(3)
select @hh=datepart(hh,@DateTime)
select @mi=datepart(mi,@DateTime)
select @ss=datepart(ss,@DateTime)
if(len(@hh)<2)
set @hh='0'+@hh
if(len(@mi)<2)
set @mi='0'+@mi
if(len(@ss)<2)
set @ss='0'+@ss
select @RetVal= @hh + ':'+ @mi + ':' + @ss


RETURN(@RetVal)
END

Rate

Share

Share

Rate