• declare @d datetime = '2/1/2014 05:28:13 AM'

    select dateadd(HOUR,-3,@d)