Use integer timestamps for duration and pin the test clock to a whole second so SQLite round-trips stay stable.