SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)

DATEDIFF(DAY, '2026-08-31 23:59:59', '2026-09-01 00:00:01') returns 1 day. Only 2 seconds passed in...