Assuming you mean time as something like HH:MM:SS, this may work:DECLARE @seconds INTSELECT @seconds =...