Adding a value to a 'datetime' column caused an overflow.(Error in MS-SQL)

90 Views Asked by At

My code-

SELECT dbo.NumericSamplesDelByTapan.TagID, dbo.Tags.TagName, dbo.Tags.Location
,(SELECT  DATEADD(Millisecond, FLOOR((dbo.NumericSamplesDelByTapan.SampleDateTime - 599266080000000000) % (10000000 * 60) / 10000)
, DATEADD(Minute, FLOOR((dbo.NumericSamplesDelByTapan.SampleDateTime - 599266080000000000) / (10000000 * 60) + 330), '01-01-1900')) AS EXPR1) AS TimeStamp
, dbo.NumericSamplesDelByTapan.SampleValue

FROM  dbo.Tags 
INNER JOIN dbo.NumericSamplesDelByTapan 
  ON dbo.Tags.ID = dbo.NumericSamplesDelByTapan.TagID
0

There are 0 best solutions below