Convert milliseconds to Hours/Minutes/Seconds printable format in TSQL.

milliseconds.sql

	declare @ms bigint = 123456789;
	declare @start datetime = '1/1/2000';
	declare @date datetime = dateadd(millisecond, @ms, @start);
	declare @day_diff int = datediff(day, @start, @date);
	declare @time time = cast(@date as time);

	declare @value varchar(max) = concat(
		@day_diff, ' Day(s) ',
		format(@time, 'hh'), ' Hour(s) ',
		format(@time, 'mm'), ' Minute(s) ',
		format(@time, 'ss'), ' Seconds(s) ',
		format(@time, 'fff'), ' Milliseconds(s) ');

	print @value;