fix 2.5 syntaxes
set UTC timezone on the connection here so we can get consistent results
tweak the timings here to maximize chance of test success