TST: lock down timeseries now tests, xref #18666
See the comment attached to `test_to_datetime_today`.  This test is not deterministic, will fail to detect the change introduced by #18666 1 hour out of each day.

- [x] tests added / passed
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`