Add or subtract time for given date

-- Get London time -- GMT : 5:30 so take 330 minute -- BST: 4:30 so take 270 minute declare @createTime datetime set @createTime = '2014-01-09 10:39' select convert(varchar, dateadd(minute, -330, @createTime), 100); declare @createTime datetime set @createTime = '2014-01-09 10:39' select convert(varchar, dateadd(minute, -270, @createTime), 100);