fix(mysql): don't print milliseconds if date precision is 0

[ephys]

Pull Request Checklist

• Have you added new tests to prevent regressions?
• If a documentation update is necessary, have you opened a PR to the documentation repository?
• Did you update the typescript typings accordingly (if applicable)?
• Does the description below contain a link to an existing issue (Closes #[issue]) or a description of the issue you are solving?
• Does the name of your PR follow our conventions?

Description Of Change

This PR is an updated version of PR #13145

Looks like the bug was fixed, so I only added a regression test

Closes #13145
Closes #12717

[ephys]

Interesting that it was fixed for mssql but not mysql

It was caused by us comparing a date without milliseconds in the database to a date with milliseconds in the query

It's not truly fixed, because the same problem will occur for precision 1 & 2, but due to a bug in dayjs, I have not fixed that yet

Alternatively we could drop dayjs.format here, and format things ourselves

[WikiRik]

Implementing my suggestion is optional, we can also fix it when we migrate this test suite to TS