Hi,
I have this
CREATE function [dbo].[sp_DecToHHMM]
(@time DECIMAL(5,2))
RETURNS nvarchar(30)
As
BEGIN
declare @additional nvarchar(30)
select @additional=replace(cast(convert(decimal(10,2),cast(@time as int)+((@time-cast(@time as int))*.60)) as varchar),'.',':')
RETURN @additional
END
When I run this:-
select [dbo].[sp_DecToHHMM] ( 2 ) output: 2:00 I want 02:00
select [dbo].[sp_DecToHHMM] ( 123.50 ) output 123:30
Please advise.
Regards,
Micheale