collation conflict between two databases

Below error coming when collation conflict between two databases: Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Resolution: INNER JOIN [test1\test1].CRM_PROD_MSCRM.dbo.Brit_TobaExtensionBase BTE ON BTE.Brit_BRMCode COLLATE DATABASE_DEFAULT =O.CRMID COLLATE DATABASE_DEFAULT

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);