BUG: Fix dt64[non_nano] + some_offsets incorrectly rounding #51967

Job	Run time
Test install requirements-dev.txt	1m 48s
Build Docker Dev Environment	2m 16s
ASV Benchmarks	30m 31s
Docstring validation, typing, and other manual pre-commit hooks	16m 0s
	50m 35s

Provide feedback