• CONVERT(TIME,DATEADD (ms, @YOURMILLISECONDS, 0))