I have a nvarchar(6) column which holds time. Such as 153000 for 3:30:00 (hhmmss).
Tried the convert 8, 108 but that doesn't seem to do a thing.
asked
Trying to convert a Varchar(6) to time data stored as hhmmss
declare @x as nvarchar(6)
set @x = '153000'
select timefromparts(
left(right('000000'+@x,6),2),
left(right(right('000000'+@x,6),4),2),
right(right('000000'+@x,6),2)
,0,0)
22 People are following this question.
