Question of the Day

Adding a Lot of Seconds

When does this code work and when does it fail?

DECLARE @BaseDate DATETIME = '1900-01-01';

SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];