Why datetime type mismatches silently corrupt Oracle → SQL Server migrations
Oracle's DATE type stores time at second precision. SQL Server's datetime2 behaves differently for implicit casts. Without explicit handling, migrated DATE values lose their time component — breaking any query that relies on time-sensitive filtering. This post documents the pattern and the remediation approach used across multiple migrations.