Hi! I have below code in Sql for add 2 in hour it's not worked. Who is you can help me?
declare @CAMEDATE VARCHAR(25)='26.07.2017 08:00'
declare @dat3 datetime
set @dat3 = CONVERT(DATETIME, CONVERT(VARCHAR(25), SUBSTRING(@CAMEDATE,0,12)+' '+CONVERT(VARCHAR(25),DATEPART(HH, @CAMEDATE)+2)+':'+CONVERT(VARCHAR(25),DATEPART(MI, @CAMEDATE))),103)
print @dat3
Result: 26.07.2017 10:00