• Going back to school

    declare @MILI bigint

    set @mili= 1*60*60*1000+2010

    select @mili

    ,@Mili/(1000*60*60) as Hour

    ,(@Mili%(1000*60*60))/(1000*60)as Minutes

    ,((@Mili%(1000*60*60))%(1000*60))/1000 as Seconds

    ,((@Mili%(1000*60*60))%(1000*60))%1000 as MiliSecs

    John Smith